BMUG PD-ROM A

home *** CD-ROM | disk | FTP | other *** search
/ BMUG PD-ROM A / PD-ROM A.iso / Business / Random / Optima / Best Answer™ Demo
MacOS Executable | 1989-05-31 | 116.3 KB | [APPL/BEST]
open in:
MacOS 8.1 extracted |
Win98 extracted |
DOS extracted
view JSON data |
view as text

This file was processed as: MacOS Executable (executable/macOSExecutable).

You can browse this item here: Best Answer™ Demo
Confidence	Program	Detection	Match Type	Support
`100%`	dexvert	MacOS Executable `(executable/macOSExecutable)`	magic	Supported
`10%`	dexvert	MacBinary `(archive/macBinary)`	fallback	Supported
`100%`	file	MacBinary II, inited, bundle, Tue Dec 8 09:28:38 1987, modified Wed May 31 15:09:43 1989, creator 'BEST', type application "Best Answer� Demo", at 0x80 118826 bytes resource Apple HFS/HFS+ resource fork, map offset 0x1c550, map length 0xada, data length 0x1c450, at 16 0x000001ff, nextResourceMap 0x31604, fileRef 0x2f2, list offset 0x1c, name offset 0xada, 15 types, 0x42455354 'BEST' * 1 resource offset 0x7a	default (weak)
`99%`	file	data	default
`74%`	TrID	Macintosh Application (MacBinary)	default
`25%`	TrID	MacBinary 2	default (weak)
`50%`	lsar	MacBinary	default
id metadata
key	value
macFileType	`[APPL]`
macFileCreator	`[BEST]`
hex view
+--------+-------------------------+-------------------------+--------+--------+
|00000000| 00 11 42 65 73 74 20 41 | 6e 73 77 65 72 aa 20 44 |..Best A|nswer. D|
|00000010| 65 6d 6f 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |emo.....|........|
|00000020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000040| 00 41 50 50 4c 42 45 53 | 54 21 00 00 00 00 00 00 |.APPLBES|T!......|
|00000050| 00 00 00 00 00 00 00 00 | 01 d0 2a 9d e1 bd 16 a0 |........|..*.....|
|00000060| a9 e8 f7 00 00 0c 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000070| 00 00 00 00 00 00 00 00 | 00 00 81 81 74 f7 00 00 |........|....t...|
|00000080| 00 00 01 00 00 01 c5 50 | 00 01 c4 50 00 00 0a da |.......P|...P....|
|00000090| 00 00 01 ff ff ff ff 80 | 00 00 01 80 00 00 01 80 |........|........|
|000000a0| 00 00 01 ff ff ff ff 80 | 00 00 01 80 00 00 01 80 |........|........|
|000000b0| 11 42 65 73 74 20 41 6e | 73 77 65 72 aa 20 44 65 |.Best An|swer. De|
|000000c0| 6d 6f 02 00 00 00 41 50 | 50 4c 42 45 53 54 21 0c |mo....AP|PLBEST!.|
|000000d0| 00 00 41 50 50 4c 42 45 | 53 54 21 0c 00 00 00 00 |..APPLBE|ST!.....|
|000000e0| 00 00 66 e1 00 00 00 00 | 00 00 00 00 00 00 00 00 |..f.....|........|
|000000f0| 00 00 9d e1 bd 16 00 00 | 00 00 00 01 d0 2a 01 80 |........|.....*..|
|00000100| 00 00 01 ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000110| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000120| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000130| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000140| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000150| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000160| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000170| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000180| 00 00 00 01 00 00 00 00 | 1c 42 45 53 54 00 00 00 |........|.BEST...|
|00000190| 01 49 43 4e 23 00 00 00 | 00 04 4c 46 52 45 46 00 |.ICN#...|..LFREF.|
|000001a0| 00 00 00 04 4c 00 00 00 | 07 41 50 50 4c 00 00 00 |....L...|.APPL...|
|000001b0| 00 00 01 00 88 88 88 88 | 88 88 88 88 88 88 88 88 |........|........|
|000001c0| 88 88 88 88 8c 88 88 88 | cc c8 88 88 cc cc 88 88 |........|........|
|000001d0| cc cc 88 88 cc cc 88 88 | cc cc c8 88 cc cc c8 88 |........|........|
|000001e0| cc cc c8 88 cc cc c8 88 | cc cc c8 88 cc cc c8 88 |........|........|
|000001f0| cc cc c8 88 cc cc c8 88 | cc cc c8 88 cc cc c8 88 |........|........|
|00000200| cc cc c8 88 cc cc c8 88 | ec cc c8 88 ec cc c8 88 |........|........|
|00000210| ee ce c8 88 ee ee 88 88 | ee ee 88 88 ee ec 88 88 |........|........|
|00000220| ee e8 88 88 8e 88 88 88 | 88 88 88 88 88 88 88 88 |........|........|
|00000230| 88 88 88 88 ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000240| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000250| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000260| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000270| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000280| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|00000290| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000002a0| ff ff ff ff ff ff ff ff | ff ff ff ff ff ff ff ff |........|........|
|000002b0| ff ff ff ff 00 00 00 0c | 00 44 00 50 00 b9 01 ae |........|.D.P....|
|000002c0| 4a 38 55 55 00 00 00 2c | 01 0e ff ff 01 1e 01 df |J8UU...,|........|
|000002d0| 00 01 01 00 00 02 00 01 | 00 10 00 00 00 00 15 68 |........|.......h|
|000002e0| 6f 72 69 7a 6f 6e 74 61 | 6c 20 73 63 72 6f 6c 6c |orizonta|l scroll|
|000002f0| 20 62 61 72 00 00 00 2a | ff ff 01 de 01 0f 01 ee | bar...*|........|
|00000300| 00 01 01 00 00 02 00 01 | 00 10 00 00 00 00 13 76 |........|.......v|
|00000310| 65 72 74 69 63 61 6c 20 | 73 63 72 6f 6c 6c 20 62 |ertical |scroll b|
|00000320| 61 72 00 00 00 48 03 e7 | 00 00 00 00 00 00 00 00 |ar...H..|........|
|00000330| 00 00 d2 fb 04 45 64 69 | 74 04 55 6e 64 6f 00 5a |.....Edi|t.Undo.Z|
|00000340| 00 00 01 2d 00 00 00 00 | 03 43 75 74 00 58 00 00 |...-....|.Cut.X..|
|00000350| 04 43 6f 70 79 00 43 00 | 00 05 50 61 73 74 65 00 |.Copy.C.|..Paste.|
|00000360| 56 00 00 05 43 6c 65 61 | 72 00 00 00 00 00 00 00 |V...Clea|r.......|
|00000370| 00 0a 80 00 00 03 00 00 | 00 01 80 00 00 00 00 0e |........|........|
|00000380| 0d 4d 61 78 69 6d 69 7a | 69 6e 67 2e 2e 2e 00 00 |.Maximiz|ing.....|
|00000390| 00 0e 0d 4d 69 6e 69 6d | 69 7a 69 6e 67 2e 2e 2e |...Minim|izing...|
|000003a0| 00 00 00 87 03 e6 00 00 | 00 00 00 00 00 00 ff ff |........|........|
|000003b0| ff ff 06 46 6f 72 6d 61 | 74 0a 39 2e 39 39 39 39 |...Forma|t.9.9999|
|000003c0| 65 2b 39 39 00 45 00 00 | 01 39 00 30 00 00 03 39 |e+99.E..|.9.0...9|
|000003d0| 2e 39 00 31 00 00 04 39 | 2e 39 39 00 32 00 00 05 |.9.1...9|.99.2...|
|000003e0| 39 2e 39 39 39 00 33 00 | 00 06 39 2e 39 39 39 39 |9.999.3.|..9.9999|
|000003f0| 00 34 00 00 07 39 2e 39 | 39 39 39 39 00 35 00 00 |.4...9.9|9999.5..|
|00000400| 08 39 2e 39 39 39 39 39 | 39 00 36 00 00 09 39 2e |.9.99999|9.6...9.|
|00000410| 39 39 39 39 39 39 39 00 | 37 00 00 0a 39 2e 39 39 |9999999.|7...9.99|
|00000420| 39 39 39 39 39 39 00 38 | 00 00 00 00 00 00 15 00 |999999.8|........|
|00000430| 7e 00 80 00 bc 01 70 00 | 01 01 00 00 00 00 00 00 |~.....p.|........|
|00000440| 00 17 70 00 00 00 00 50 | 00 03 00 00 00 00 00 08 |..p....P|........|
|00000450| 00 98 00 1c 00 d4 04 02 | 4f 4b 00 00 00 00 00 24 |........|OK.....$|
|00000460| 00 98 00 38 00 d4 04 06 | 43 61 6e 63 65 6c 00 00 |...8....|Cancel..|
|00000470| 00 00 00 18 00 04 00 28 | 00 4d 88 0c 47 6f 20 74 |.......(|.M..Go t|
|00000480| 6f 20 63 65 6c 6c 3a 20 | 00 00 00 00 00 18 00 53 |o cell: |.......S|
|00000490| 00 28 00 7d 90 02 41 31 | 00 00 00 1e 1d 54 6f 6f |.(.}..A1|.....Too|
|000004a0| 20 6d 61 6e 79 20 63 65 | 6c 6c 73 20 77 65 72 65 | many ce|lls were|
|000004b0| 20 73 65 6c 65 63 74 65 | 64 2e 00 00 00 32 31 41 | selecte|d....21A|
|000004c0| 64 6a 75 73 74 61 62 6c | 65 20 63 65 6c 6c 73 20 |djustabl|e cells |
|000004d0| 63 61 6e 20 6f 6e 6c 79 | 20 63 6f 6e 74 61 69 6e |can only| contain|
|000004e0| 20 6e 75 6d 65 72 69 63 | 20 76 61 6c 75 65 73 2e | numeric| values.|
|000004f0| 00 00 00 2d 2c 43 6f 6e | 73 74 72 61 69 6e 74 20 |...-,Con|straint |
|00000500| 63 65 6c 6c 73 20 63 61 | 6e 20 6f 6e 6c 79 20 63 |cells ca|n only c|
|00000510| 6f 6e 74 61 69 6e 20 61 | 20 66 6f 72 6d 75 6c 61 |ontain a| formula|
|00000520| 2e 00 00 00 2b 2a 4f 62 | 6a 65 63 74 69 76 65 20 |....+*Ob|jective |
|00000530| 63 65 6c 6c 20 63 61 6e | 20 6f 6e 6c 79 20 63 6f |cell can| only co|
|00000540| 6e 74 61 69 6e 20 61 20 | 66 6f 72 6d 75 6c 61 2e |ntain a |formula.|
|00000550| 00 00 00 39 38 49 6e 76 | 61 6c 69 64 20 53 59 4c |...98Inv|alid SYL|
|00000560| 4b 20 70 61 72 6d 20 65 | 6e 63 6f 75 6e 74 65 72 |K parm e|ncounter|
|00000570| 65 64 20 77 68 69 6c 65 | 20 72 65 61 64 69 6e 67 |ed while| reading|
|00000580| 20 73 70 72 65 61 64 73 | 68 65 65 74 2e 00 00 00 | spreads|heet....|
|00000590| 3e 3d 49 6e 76 61 6c 69 | 64 20 58 2c 59 20 63 6f |>=Invali|d X,Y co|
|000005a0| 6f 72 64 69 6e 61 74 65 | 20 65 6e 63 6f 75 6e 74 |ordinate| encount|
|000005b0| 65 72 65 64 20 77 68 69 | 6c 65 20 72 65 61 64 69 |ered whi|le readi|
|000005c0| 6e 67 20 73 70 72 65 61 | 64 73 68 65 65 74 2e 00 |ng sprea|dsheet..|
|000005d0| 00 00 3e 3d 4e 6f 20 63 | 65 6c 6c 20 76 61 6c 75 |..>=No c|ell valu|
|000005e0| 65 20 66 6f 6c 6c 6f 77 | 65 64 20 4b 2d 53 59 4c |e follow|ed K-SYL|
|000005f0| 4b 20 70 61 72 6d 20 77 | 68 69 6c 65 20 72 65 61 |K parm w|hile rea|
|00000600| 64 69 6e 67 20 73 70 72 | 65 61 64 73 68 65 65 74 |ding spr|eadsheet|
|00000610| 2e 00 00 00 2b 2a 55 6e | 61 62 6c 65 20 74 6f 20 |....+*Un|able to |
|00000620| 65 76 61 6c 75 61 74 65 | 20 66 6f 72 6d 75 6c 61 |evaluate| formula|
|00000630| 20 69 6e 20 73 70 72 65 | 61 64 73 68 65 65 74 2e | in spre|adsheet.|
|00000640| 00 00 00 33 32 42 6f 75 | 6e 64 73 20 65 72 72 6f |...32Bou|nds erro|
|00000650| 72 20 65 6e 63 6f 75 6e | 74 65 72 65 64 20 77 68 |r encoun|tered wh|
|00000660| 69 6c 65 20 72 65 61 64 | 69 6e 67 20 73 70 72 65 |ile read|ing spre|
|00000670| 61 64 73 68 65 65 74 00 | 00 00 1f 1e 55 6e 61 62 |adsheet.|....Unab|
|00000680| 6c 65 20 74 6f 20 72 65 | 61 64 20 69 6e 20 73 70 |le to re|ad in sp|
|00000690| 72 65 61 64 73 68 65 65 | 74 2e 00 00 00 28 27 55 |readshee|t....('U|
|000006a0| 6e 61 62 6c 65 20 74 6f | 20 72 65 70 6c 61 63 65 |nable to| replace|
|000006b0| 20 6f 6c 64 20 73 70 72 | 65 61 64 73 68 65 65 74 | old spr|eadsheet|
|000006c0| 20 66 69 6c 65 2e 00 00 | 00 28 27 55 6e 61 62 6c | file...|.('Unabl|
|000006d0| 65 20 74 6f 20 72 65 70 | 6c 61 63 65 20 6e 65 77 |e to rep|lace new|
|000006e0| 20 73 70 72 65 61 64 73 | 68 65 65 74 20 66 69 6c | spreads|heet fil|
|000006f0| 65 2e 00 00 00 21 20 55 | 6e 61 62 6c 65 20 74 6f |e....! U|nable to|
|00000700| 20 73 61 76 65 20 73 70 | 72 65 61 64 73 68 65 65 | save sp|readshee|
|00000710| 74 20 66 69 6c 65 2e 00 | 00 00 02 00 01 00 00 00 |t file..|........|
|00000720| 02 00 01 00 00 00 02 00 | 01 00 00 00 02 00 01 00 |........|........|
|00000730| 00 00 02 00 01 00 00 00 | 02 00 01 00 00 00 02 00 |........|........|
|00000740| 01 00 00 00 02 00 01 00 | 00 00 02 00 01 00 00 00 |........|........|
|00000750| 02 00 01 00 00 00 15 00 | 3c 00 4c 00 aa 01 a9 00 |........|<.L.....|
|00000760| 01 01 00 00 00 00 00 00 | 00 0f a0 00 00 00 00 8a |........|........|
|00000770| 00 06 00 00 00 00 00 0a | 01 10 00 1e 01 4c 04 04 |........|.....L..|
|00000780| 53 74 6f 70 00 00 00 00 | 00 2a 00 33 00 5f 01 4b |Stop....|.*.3._.K|
|00000790| 80 00 00 00 00 00 00 48 | 00 3c 00 58 00 b4 88 11 |.......H|.<.X....|
|000007a0| 43 75 72 72 65 6e 74 20 | 4f 62 6a 65 63 74 69 76 |Current |Objectiv|
|000007b0| 65 11 00 00 00 00 00 31 | 00 bd 00 42 00 f7 88 01 |e......1|...B....|
|000007c0| 30 76 00 00 00 00 00 0c | 00 18 00 1c 00 f6 88 00 |0v......|........|
|000007d0| 00 00 00 00 00 31 00 5f | 00 41 00 b4 88 0b 49 74 |.....1._|.A....It|
|000007e0| 65 72 61 74 69 6f 6e 20 | 23 5f 00 00 00 00 00 47 |eration |#_.....G|
|000007f0| 00 bd 00 58 01 42 88 01 | 30 20 00 00 00 8c 00 07 |...X.B..|0 ......|
|00000800| 00 00 00 00 00 d8 00 0e | 00 ec 00 56 04 06 54 6f |........|...V..To|
|00000810| 70 69 63 73 00 00 00 00 | 00 d8 01 10 00 ec 01 58 |pics....|.......X|
|00000820| 04 06 43 61 6e 63 65 6c | 00 00 00 00 00 18 00 08 |..Cancel|........|
|00000830| 00 ce 01 58 00 00 00 00 | 00 00 00 d8 00 64 00 ec |...X....|.....d..|
|00000840| 00 ac 04 04 4e 65 78 74 | 00 00 00 00 00 d8 00 ba |....Next|........|
|00000850| 00 ec 01 02 04 08 50 72 | 65 76 69 6f 75 73 00 00 |......Pr|evious..|
|00000860| 00 00 00 04 00 0a 00 14 | 01 51 80 00 00 00 00 00 |........|.Q......|
|00000870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 1a |........|........|
|00000880| 00 0c 00 ca 00 9e 40 02 | 13 88 00 00 00 1c 1b 44 |......@.|.......D|
|00000890| 65 74 65 72 6d 69 6e 69 | 6e 67 20 43 6f 65 66 66 |etermini|ng Coeff|
|000008a0| 69 63 69 65 6e 74 73 2e | 2e 2e 00 00 00 1c 1b 43 |icients.|.......C|
|000008b0| 6f 6e 64 75 63 74 69 6e | 67 20 50 6f 73 74 20 41 |onductin|g Post A|
|000008c0| 6e 61 6c 79 73 69 73 2e | 2e 2e 00 00 00 33 32 42 |nalysis.|.....32B|
|000008d0| 6f 75 6e 64 73 20 65 72 | 72 6f 72 20 65 6e 63 6f |ounds er|ror enco|
|000008e0| 75 6e 74 65 72 65 64 20 | 77 68 69 6c 65 20 72 65 |untered |while re|
|000008f0| 61 64 69 6e 67 20 73 70 | 72 65 61 64 73 68 65 65 |ading sp|readshee|
|00000900| 74 00 00 00 02 00 02 00 | 00 00 15 00 30 00 63 00 |t.......|....0.c.|
|00000910| 73 01 9d 00 01 01 00 00 | 00 00 00 00 00 03 e8 00 |s.......|........|
|00000920| 00 00 00 36 00 02 00 00 | 00 00 00 25 00 f8 00 39 |...6....|...%...9|
|00000930| 01 34 04 06 43 61 6e 63 | 65 6c 00 00 00 00 00 0c |.4..Canc|el......|
|00000940| 00 0a 00 1c 01 38 88 04 | 5e 30 5e 31 00 00 00 00 |.....8..|^0^1....|
|00000950| 00 28 00 0b 00 38 00 ef | 80 00 00 00 00 1d 1c 52 |.(...8..|.......R|
|00000960| 65 63 61 6c 63 75 6c 61 | 74 69 6e 67 20 53 70 72 |ecalcula|ting Spr|
|00000970| 65 61 64 73 68 65 65 74 | 2e 2e 2e 00 00 00 0c 00 |eadsheet|........|
|00000980| 3e 00 50 00 c3 01 ae 4e | 1f 55 55 00 00 00 3c 00 |>.P....N|.UU...<.|
|00000990| 02 00 00 00 00 00 65 00 | 12 00 79 00 54 04 06 46 |......e.|..y.T..F|
|000009a0| 69 6e 64 65 72 00 00 00 | 00 00 0e 00 4c 00 59 01 |inder...|....L.Y.|
|000009b0| 4e 88 04 5e 30 5e 31 00 | 00 00 00 00 9e 00 f8 00 |N..^0^1.|........|
|000009c0| b1 01 34 88 05 49 44 3d | 5e 32 9e 00 00 00 4a 00 |..4..ID=|^2....J.|
|000009d0| 03 00 00 00 00 00 57 00 | 12 00 6b 00 4a 04 02 4f |......W.|..k.J..O|
|000009e0| 4b 00 00 00 00 00 57 00 | 5f 00 6b 00 9b 04 04 48 |K.....W.|_.k....H|
|000009f0| 65 6c 70 00 00 00 00 00 | 0e 00 4c 00 4f 01 4e 88 |elp.....|..L.O.N.|
|00000a00| 04 5e 30 5e 31 00 00 00 | 00 00 9e 00 f8 00 b1 01 |.^0^1...|........|
|00000a10| 34 88 05 49 44 3d 5e 32 | 44 00 00 00 15 00 1e 00 |4..ID=^2|D.......|
|00000a20| 10 00 41 01 f2 00 01 01 | 00 00 00 00 00 00 00 1b |..A.....|........|
|00000a30| 58 00 00 00 00 15 00 4a | 00 88 00 b7 01 78 00 01 |X......J|.....x..|
|00000a40| 01 00 00 00 00 00 00 00 | 1f 40 00 00 00 00 15 00 |........|.@......|
|00000a50| 40 00 70 00 d2 01 90 00 | 01 01 00 00 00 00 00 00 |@.p.....|........|
|00000a60| 00 23 28 00 00 00 00 5c | 00 04 00 00 00 00 00 07 |.#(....\|........|
|00000a70| 01 98 00 1b 01 d4 04 02 | 4f 4b 00 00 00 00 00 07 |........|OK......|
|00000a80| 01 4c 00 1b 01 88 04 06 | 43 61 6e 63 65 6c 00 00 |.L......|Cancel..|
|00000a90| 00 00 00 0a 00 0a 00 1a | 00 29 88 05 43 65 6c 6c |........|.)..Cell|
|00000aa0| 20 61 00 00 00 00 00 0a | 00 29 00 1a 00 5a 88 05 | a......|.)...Z..|
|00000ab0| 61 61 31 31 31 08 00 00 | 00 00 00 0a 00 5e 00 1a |aa111...|.....^..|
|00000ac0| 01 3e 90 00 00 00 00 b4 | 00 06 00 00 00 00 00 0b |.>......|........|
|00000ad0| 00 08 00 1b 00 f0 88 1c | 5f 5f 5f 5f 5f 5f 5f 5f |........|________|
|00000ae0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000af0| 5f 5f 5f 5f 00 00 00 00 | 00 20 00 00 00 30 00 78 |____....|. ...0.x|
|00000b00| 88 05 43 65 6c 6c 3a 5f | 00 00 00 00 00 30 00 00 |..Cell:_|.....0..|
|00000b10| 00 40 00 78 88 0d 53 68 | 61 64 6f 77 20 50 72 69 |.@.x..Sh|adow Pri|
|00000b20| 63 65 3a 00 00 00 00 00 | 00 20 00 78 00 30 00 b0 |ce:.....|. .x.0..|
|00000b30| 88 05 61 61 31 31 31 77 | 00 00 00 00 00 30 00 78 |..aa111w|.....0.x|
|00000b40| 00 40 00 ed 88 0b 31 32 | 33 34 35 36 37 38 39 30 |.@....12|34567890|
|00000b50| 31 31 00 00 00 00 00 50 | 00 58 00 64 00 94 04 02 |11.....P|.X.d....|
|00000b60| 4f 4b 00 00 00 00 00 02 | 00 45 00 14 00 a7 88 0c |OK......|.E......|
|00000b70| 53 68 61 64 6f 77 20 50 | 72 69 63 65 00 00 01 48 |Shadow P|rice...H|
|00000b80| 00 0a 00 00 00 00 00 70 | 00 71 00 84 00 ad 04 02 |.......p|.q......|
|00000b90| 4f 4b 00 00 00 00 00 0a | 00 07 00 18 01 1b 88 24 |OK......|.......$|
|00000ba0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000bb0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00000bc0| 5f 5f 5f 5f 00 00 00 00 | 00 20 00 08 00 30 00 78 |____....|. ...0.x|
|00000bd0| 88 10 41 64 6a 75 73 74 | 61 62 6c 65 20 43 65 6c |..Adjust|able Cel|
|00000be0| 6c 3a 00 00 00 00 00 20 | 00 a8 00 30 00 e8 88 05 |l:..... |...0....|
|00000bf0| 41 31 31 31 31 43 00 00 | 00 00 00 40 00 08 00 50 |A1111C..|...@...P|
|00000c00| 00 a8 88 14 41 63 74 75 | 61 6c 20 43 6f 6e 74 72 |....Actu|al Contr|
|00000c10| 69 62 75 74 69 6f 6e 3a | 00 00 00 00 00 30 00 08 |ibution:|.....0..|
|00000c20| 00 40 00 a8 88 15 4d 69 | 6e 69 6d 75 6d 20 43 6f |.@....Mi|nimum Co|
|00000c30| 6e 74 72 69 62 75 74 69 | 6f 6e 3a a8 00 00 00 00 |ntributi|on:.....|
|00000c40| 00 50 00 08 00 60 00 a8 | 88 15 4d 61 78 69 6d 75 |.P...`..|..Maximu|
|00000c50| 6d 20 43 6f 6e 74 72 69 | 62 75 74 69 6f 6e 3a a8 |m Contri|bution:.|
|00000c60| 00 00 00 00 00 30 00 a8 | 00 40 01 1c 88 09 31 32 |.....0..|.@....12|
|00000c70| 33 34 35 36 37 38 39 40 | 00 00 00 00 00 40 00 a8 |3456789@|.....@..|
|00000c80| 00 50 01 1c 88 09 31 32 | 33 34 35 36 37 38 39 30 |.P....12|34567890|
|00000c90| 00 00 00 00 00 50 00 a8 | 00 60 01 1c 88 09 31 32 |.....P..|.`....12|
|00000ca0| 33 34 35 36 37 38 39 50 | 00 00 00 00 00 01 00 48 |3456789P|.......H|
|00000cb0| 00 13 00 d0 88 12 43 6f | 6e 74 72 69 62 75 74 69 |......Co|ntributi|
|00000cc0| 6f 6e 20 52 61 6e 67 65 | 00 00 00 64 03 eb 00 00 |on Range|...d....|
|00000cd0| 00 00 00 00 00 00 ff ff | ff f7 0c 4f 70 74 69 6d |........|...Optim|
|00000ce0| 69 7a 61 74 69 6f 6e 08 | 4d 61 78 69 6d 69 7a 65 |ization.|Maximize|
|00000cf0| 00 4d 00 00 08 4d 69 6e | 69 6d 69 7a 65 00 4e 00 |.M...Min|imize.N.|
|00000d00| 00 01 2d 00 00 00 00 12 | 43 6f 6e 74 72 69 62 75 |..-.....|Contribu|
|00000d10| 74 69 6f 6e 20 52 61 6e | 67 65 00 54 00 00 0c 53 |tion Ran|ge.T...S|
|00000d20| 68 61 64 6f 77 20 50 72 | 69 63 65 00 59 00 00 00 |hadow Pr|ice.Y...|
|00000d30| 00 00 00 1e 1d 54 6f 6f | 20 6d 61 6e 79 20 63 65 |.....Too| many ce|
|00000d40| 6c 6c 73 20 77 65 72 65 | 20 73 65 6c 65 63 74 65 |lls were| selecte|
|00000d50| 64 2e 00 00 00 02 00 03 | 00 00 00 31 03 e8 00 00 |d.......|...1....|
|00000d60| 00 00 00 00 00 00 ff ff | ff fb 01 14 15 41 62 6f |........|.....Abo|
|00000d70| 75 74 20 42 65 73 74 20 | 41 6e 73 77 65 72 aa 2e |ut Best |Answer..|
|00000d80| 2e 2e 00 00 00 00 01 2d | 00 00 00 00 00 00 00 00 |.......-|........|
|00000d90| 27 00 3e 00 44 01 36 01 | b6 00 00 01 00 00 00 00 |'.>.D.6.|........|
|00000da0| 00 00 00 13 88 12 41 62 | 6f 75 74 20 42 65 73 74 |......Ab|out Best|
|00000db0| 20 41 6e 73 77 65 72 aa | 00 00 00 56 55 0d 0d 0d | Answer.|...VU...|
|00000dc0| 54 68 65 20 22 48 65 6c | 70 22 20 66 65 61 74 75 |The "Hel|p" featu|
|00000dd0| 72 65 20 69 73 20 6f 6e | 6c 79 20 61 76 61 69 6c |re is on|ly avail|
|00000de0| 61 62 6c 65 20 77 69 74 | 68 20 76 65 72 73 69 6f |able wit|h versio|
|00000df0| 6e 20 33 2e 32 20 6f 72 | 20 6c 61 74 65 72 20 6f |n 3.2 or| later o|
|00000e00| 66 20 74 68 65 20 73 79 | 73 74 65 6d 20 66 69 6c |f the sy|stem fil|
|00000e10| 65 2e 00 00 00 0c 00 44 | 00 36 00 bc 01 24 3a 98 |e......D|.6...$:.|
|00000e20| 55 55 00 00 00 54 00 02 | 00 00 00 00 00 3a 00 19 |UU...T..|.....:..|
|00000e30| 00 4c 00 63 04 02 4f 4b | 00 00 00 00 00 3a 00 8c |.L.c..OK|.....:..|
|00000e40| 00 4c 00 d6 04 06 43 61 | 6e 63 65 6c 00 00 00 00 |.L....Ca|ncel....|
|00000e50| 00 0c 00 14 00 2d 00 df | 88 20 52 65 76 65 72 74 |.....-..|. Revert|
|00000e60| 20 74 6f 20 73 61 76 65 | 64 20 76 65 72 73 69 6f | to save|d versio|
|00000e70| 6e 20 6f 66 20 22 5e 30 | 22 3f 00 00 00 0c 00 3c |n of "^0|"?.....<|
|00000e80| 00 32 00 92 01 20 36 b0 | 44 44 00 00 00 5e 00 03 |.2... 6.|DD...^..|
|00000e90| 00 00 00 00 00 3a 00 19 | 00 4c 00 63 04 03 59 65 |.....:..|.L.c..Ye|
|00000ea0| 73 6e 00 00 00 00 00 56 | 00 8d 00 68 00 d7 04 06 |sn.....V|...h....|
|00000eb0| 43 61 6e 63 65 6c 00 00 | 00 00 00 56 00 19 00 68 |Cancel..|...V...h|
|00000ec0| 00 63 04 03 20 4e 6f 4e | 00 00 00 00 00 0c 00 14 |.c.. NoN|........|
|00000ed0| 00 2d 00 df 88 15 53 61 | 76 65 20 63 68 61 6e 67 |.-....Sa|ve chang|
|00000ee0| 65 73 20 74 6f 20 22 5e | 30 22 3f 27 00 00 00 59 |es to "^|0"?'...Y|
|00000ef0| 03 e9 00 00 00 00 00 00 | 00 00 ff ff ff bf 04 46 |........|.......F|
|00000f00| 69 6c 65 04 4f 70 65 6e | 00 4f 00 00 05 43 6c 6f |ile.Open|.O...Clo|
|00000f10| 73 65 00 2e 00 00 04 53 | 61 76 65 00 53 00 00 0a |se.....S|ave.S...|
|00000f20| 53 61 76 65 20 41 73 2e | 2e 2e 00 00 00 00 06 52 |Save As.|.......R|
|00000f30| 65 76 65 72 74 00 52 00 | 00 01 2d 00 00 00 00 04 |evert.R.|..-.....|
|00000f40| 51 75 69 74 00 51 00 00 | 00 00 00 00 15 00 1e 00 |Quit.Q..|........|
|00000f50| 10 00 56 01 f2 00 01 00 | 00 00 00 00 00 00 00 27 |..V.....|.......'|
|00000f60| 10 00 00 00 00 58 00 04 | 00 00 00 00 00 05 01 99 |.....X..|........|
|00000f70| 00 19 01 d5 04 02 4f 4b | 00 00 00 00 00 0a 00 0a |......OK|........|
|00000f80| 00 1a 00 29 88 05 43 65 | 6c 6c 20 6c 00 00 00 00 |...)..Ce|ll l....|
|00000f90| 00 0a 00 29 00 1a 00 5a | 88 02 5e 30 00 00 00 00 |...)...Z|..^0....|
|00000fa0| 00 22 00 08 00 32 01 d6 | 88 04 5e 32 5e 33 00 00 |."...2..|..^2^3..|
|00000fb0| 00 00 00 0a 00 5b 00 1a | 01 3b 88 02 5e 31 00 00 |.....[..|.;..^1..|
|00000fc0| 00 14 13 4e 6f 74 20 61 | 20 66 6f 72 6d 75 6c 61 |...Not a| formula|
|00000fd0| 20 63 65 6c 6c 2e 00 00 | 00 02 00 00 00 00 00 c4 | cell...|........|
|00000fe0| 03 ea 00 00 00 00 00 00 | 00 00 ff ff fd ef 04 43 |........|.......C|
|00000ff0| 65 6c 6c 12 44 65 66 69 | 6e 65 20 41 64 6a 75 73 |ell.Defi|ne Adjus|
|00001000| 74 61 62 6c 65 73 00 41 | 00 00 12 44 65 66 69 6e |tables.A|...Defin|
|00001010| 65 20 43 6f 6e 73 74 72 | 61 69 6e 74 73 00 4b 00 |e Constr|aints.K.|
|00001020| 00 10 44 65 66 69 6e 65 | 20 4f 62 6a 65 63 74 69 |..Define| Objecti|
|00001030| 76 65 00 42 00 00 01 2d | 00 00 00 00 10 53 68 6f |ve.B...-|.....Sho|
|00001040| 77 20 41 64 6a 75 73 74 | 61 62 6c 65 73 00 00 00 |w Adjust|ables...|
|00001050| 00 10 53 68 6f 77 20 43 | 6f 6e 73 74 72 61 69 6e |..Show C|onstrain|
|00001060| 74 73 00 00 00 00 0e 53 | 68 6f 77 20 4f 62 6a 65 |ts.....S|how Obje|
|00001070| 63 74 69 76 65 00 00 00 | 00 12 53 68 6f 77 20 43 |ctive...|..Show C|
|00001080| 65 6c 6c 20 43 6f 6e 74 | 65 6e 74 73 00 46 00 00 |ell Cont|ents.F..|
|00001090| 01 2d 00 00 00 00 08 47 | 6f 20 54 6f 2e 2e 2e 00 |.-.....G|o To....|
|000010a0| 47 00 00 00 00 00 09 8b | 09 8b 00 8e 00 6a 01 3e |G.......|.....j.>|
|000010b0| 00 fc 11 01 01 00 0a 00 | 8e 00 6a 01 3e 00 fc 98 |........|..j.>...|
|000010c0| 00 14 00 8e 00 68 00 b6 | 01 00 00 8e 00 6a 00 b6 |.....h..|.....j..|
|000010d0| 00 fc 00 8e 00 6a 00 b6 | 00 fc 00 00 08 fc 00 f9 |.....j..|........|
|000010e0| 11 00 10 fb 00 08 fc 00 | f9 11 00 10 fb 00 08 fc |........|........|
|000010f0| 00 f9 11 00 10 fb 00 08 | fc 00 f9 11 00 10 fb 00 |........|........|
|00001100| 08 fc 00 f9 11 00 10 fb | 00 08 fc 00 f9 11 00 10 |........|........|
|00001110| fb 00 0c fc 00 02 11 11 | 99 fc 11 00 10 fb 00 0d |........|........|
|00001120| fc 00 03 11 19 99 91 fd | 11 00 10 fb 00 0c fc 00 |........|........|
|00001130| 00 11 fe 99 fd 11 00 10 | fb 00 0c fc 00 00 19 fe |........|........|
|00001140| 99 fd 11 00 10 fb 00 0e | fc 00 00 19 fe 99 00 91 |........|........|
|00001150| fe 11 00 10 fb 00 0e fc | 00 00 19 fe 99 00 91 fe |........|........|
|00001160| 11 00 10 fb 00 0c fc 00 | 00 19 fd 99 fe 11 00 10 |........|........|
|00001170| fb 00 0c fc 00 00 19 fd | 99 fe 11 00 10 fb 00 0c |........|........|
|00001180| fc 00 00 19 fd 99 fe 11 | 00 10 fb 00 0c fc 00 00 |........|........|
|00001190| 19 fd 99 fe 11 00 10 fb | 00 0d fc 00 00 19 fd 99 |........|........|
|000011a0| 03 91 11 11 10 fb 00 0d | fc 00 00 19 fd 99 03 91 |........|........|
|000011b0| 11 11 10 fb 00 0d fc 00 | 00 19 fd 99 03 91 11 11 |........|........|
|000011c0| 10 fb 00 0d fc 00 00 19 | fd 99 03 91 11 11 10 fb |........|........|
|000011d0| 00 0d fc 00 00 19 fd 99 | 03 91 11 11 10 fb 00 0d |........|........|
|000011e0| fc 00 00 19 fd 99 03 91 | 11 11 10 fb 00 0c fc 00 |........|........|
|000011f0| 00 19 fc 99 02 11 11 10 | fb 00 0c fc 00 00 19 fc |........|........|
|00001200| 99 02 11 11 10 fb 00 0c | fc 00 00 19 fc 99 02 11 |........|........|
|00001210| 11 10 fb 00 0c fc 00 00 | 19 fc 99 02 11 11 10 fb |........|........|
|00001220| 00 0c fc 00 00 19 fc 99 | 02 11 11 10 fb 00 0c fc |........|........|
|00001230| 00 00 19 fc 99 02 11 11 | 10 fb 00 0c fc 00 00 19 |........|........|
|00001240| fc 99 02 11 11 10 fb 00 | 0c fc 00 00 19 fc 99 02 |........|........|
|00001250| 11 11 10 fb 00 0c fc 00 | 00 19 fc 99 02 11 11 10 |........|........|
|00001260| fb 00 0c fc 00 00 19 fc | 99 02 11 11 10 fb 00 0c |........|........|
|00001270| fc 00 00 19 fc 99 02 11 | 11 10 fb 00 0c fc 00 00 |........|........|
|00001280| 19 fc 99 02 11 11 10 fb | 00 0c fc 00 00 19 fc 99 |........|........|
|00001290| 02 11 11 10 fb 00 0c fc | 00 00 19 fc 99 02 11 11 |........|........|
|000012a0| 10 fb 00 0c fc 00 00 19 | fc 99 02 11 11 10 fb 00 |........|........|
|000012b0| 0c fc 00 00 19 fc 99 02 | 11 11 10 fb 00 0c fc 00 |........|........|
|000012c0| 00 19 fc 99 02 11 11 10 | fb 00 0c fc 00 00 19 fc |........|........|
|000012d0| 99 02 11 11 10 fb 00 98 | 00 14 00 b6 00 68 00 de |........|.....h..|
|000012e0| 01 00 00 b6 00 6a 00 de | 00 fc 00 b6 00 6a 00 de |.....j..|.....j..|
|000012f0| 00 fc 00 00 0c fc 00 00 | 19 fc 99 02 11 11 10 fb |........|........|
|00001300| 00 0c fc 00 00 19 fc 99 | 02 11 11 10 fb 00 0c fc |........|........|
|00001310| 00 00 19 fc 99 02 11 11 | 10 fb 00 0c fc 00 00 19 |........|........|
|00001320| fc 99 02 11 11 10 fb 00 | 0c fc 00 00 19 fc 99 02 |........|........|
|00001330| 11 11 10 fb 00 0c fc 00 | 00 19 fc 99 02 11 11 10 |........|........|
|00001340| fb 00 0c fc 00 00 19 fc | 99 02 11 11 10 fb 00 0c |........|........|
|00001350| fc 00 00 1d fc 99 02 11 | 11 10 fb 00 0c fc 00 00 |........|........|
|00001360| 1d fc 99 02 11 11 10 fb | 00 0d fc 00 01 1d d9 fd |........|........|
|00001370| 99 02 11 11 10 fb 00 0e | fc 00 01 1d d9 fe 99 03 |........|........|
|00001380| 91 11 11 10 fb 00 0e fc | 00 01 1d dd fe 99 03 d1 |........|........|
|00001390| 11 11 10 fb 00 0e fc 00 | 01 1d dd fe 99 03 d1 11 |........|........|
|000013a0| 11 10 fb 00 0e fc 00 08 | 1d dd d9 99 9d d1 11 11 |........|........|
|000013b0| 10 fb 00 0e fc 00 08 1d | dd dd 99 dd d1 11 11 10 |........|........|
|000013c0| fb 00 0d fc 00 00 1d fd | dd 03 91 11 11 10 fb 00 |........|........|
|000013d0| 0c fc 00 00 1d fd dd fe | 11 00 10 fb 00 0c fc 00 |........|........|
|000013e0| 00 1d fd dd fe 11 00 10 | fb 00 0c fc 00 00 1d fd |........|........|
|000013f0| dd fe 11 00 10 fb 00 0c | fc 00 00 1d fd dd fe 11 |........|........|
|00001400| 00 10 fb 00 0e fc 00 00 | 1d fe dd 00 d1 fe 11 00 |........|........|
|00001410| 10 fb 00 0e fc 00 00 1d | fe dd 00 d1 fe 11 00 10 |........|........|
|00001420| fb 00 0e 00 c0 fd 00 00 | 11 fe dd fd 11 00 10 fb |........|........|
|00001430| 00 0e 00 c0 fd 00 00 11 | fe dd fd 11 00 10 fb 00 |........|........|
|00001440| 0f 00 c0 fd 00 03 11 1d | dd d1 fd 11 00 10 fb 00 |........|........|
|00001450| 0e 00 c0 fd 00 02 11 11 | dd fc 11 00 10 fb 00 0a |........|........|
|00001460| 00 c0 fd 00 f9 11 00 10 | fb 00 0a 00 c0 fd 00 f9 |........|........|
|00001470| 11 00 10 fb 00 0a 00 c0 | fd 00 f9 11 00 10 fb 00 |........|........|
|00001480| 0a 00 c0 fd 00 f9 11 00 | 10 fb 00 0a 00 40 fd 00 |........|.....@..|
|00001490| f9 11 00 10 fb 00 02 ed | 00 02 ed 00 02 ed 00 02 |........|........|
|000014a0| ed 00 02 ed 00 02 ed 00 | 02 ed 00 12 02 00 00 1f |........|........|
|000014b0| fc 00 04 01 80 00 18 c0 | fe 00 00 38 fe 00 12 03 |........|...8....|
|000014c0| 00 00 19 80 fd 00 03 01 | 80 00 18 fd 00 00 60 fe |........|......`.|
|000014d0| 00 98 00 14 00 de 00 68 | 01 06 01 00 00 de 00 6a |.......h|.......j|
|000014e0| 01 06 00 fc 00 de 00 6a | 01 06 00 fc 00 00 14 10 |.......j|........|
|000014f0| 00 00 19 8f 1f f0 f1 f0 | e3 cd 9e 3c c7 8f 80 78 |........|...<...x|
|00001500| f0 fe 00 12 02 00 00 19 | fc 99 08 91 8e 23 18 cc |........|.....#..|
|00001510| cc c0 cc 60 fe 00 12 02 | 00 00 19 fc 99 08 c1 8c |...`....|........|
|00001520| 1f 18 cc cc c0 cc 60 fe | 00 14 03 00 00 19 9f fe |......`.|........|
|00001530| 99 09 98 e1 8c 33 18 cc | cc c0 cc 60 fe 00 14 10 |.....3..|...`....|
|00001540| 00 00 19 98 19 99 99 98 | 71 8c 33 18 cc cc c0 cc |........|q.3.....|
|00001550| 60 fe 00 13 03 00 00 19 | 98 fd 99 08 31 8c 33 18 |`.......|....1.3.|
|00001560| cc cc c0 cc 60 fe 00 14 | 10 00 00 1f 0f 19 98 f1 |....`...|........|
|00001570| 98 e0 cc 1f 0c c7 8c c0 | 78 60 fe 00 02 ed 00 04 |........|x`......|
|00001580| 00 80 ee 00 04 00 c0 ee | 00 04 00 c0 ee 00 04 00 |........|........|
|00001590| c0 ee 00 04 00 c0 ee 00 | 13 05 df 00 00 18 07 80 |........|........|
|000015a0| fd 00 01 07 44 fd 00 03 | 18 01 e0 00 13 05 d9 80 |....D...|........|
|000015b0| 00 18 0c c0 fd 00 01 02 | 6c fd 00 03 38 03 30 00 |........|l...8.0.|
|000015c0| 15 13 19 8f 0e 3c 0c cf | 87 19 98 f1 b2 54 00 cc |.....<..|.....T..|
|000015d0| 78 d8 18 03 30 00 15 06 | 19 99 99 18 0c cc cc fe |x...0...|........|
|000015e0| 99 09 c2 44 00 cc cc e0 | 18 03 30 00 15 13 1f 19 |...D....|..0.....|
|000015f0| 9c 18 0f cc ce 19 99 99 | 80 00 00 cc cc c0 18 03 |........|........|
|00001600| 30 00 15 13 19 9f 8e 18 | 0c cc c7 19 99 f9 80 00 |0.......|........|
|00001610| 00 cc fc c0 18 03 30 00 | 15 13 19 98 07 18 0c cc |......0.|........|
|00001620| c3 99 99 81 80 00 00 cc | c0 c0 18 03 30 00 15 13 |........|....0...|
|00001630| 19 98 93 18 0c cc c9 99 | 91 89 80 00 00 c8 c4 c0 |........|........|
|00001640| 18 63 30 00 15 13 1f 0f | 0e 0c 0c cc c7 1f e0 f1 |.c0.....|........|
|00001650| 80 00 00 f0 78 c0 18 61 | e0 00 02 ed 00 04 00 80 |....x..a|........|
|00001660| ee 00 04 00 c0 ee 00 04 | 00 80 ee 00 04 00 80 ee |........|........|
|00001670| 00 07 00 9f f0 ff 01 f0 | 00 04 00 80 ee 00 04 00 |........|........|
|00001680| 80 ee 00 02 ed 00 02 ed | 00 02 ed 00 12 0a 00 10 |........|........|
|00001690| 08 00 06 00 03 01 f0 00 | 03 fd 00 00 c0 fd 00 0c |........|........|
|000016a0| 08 00 18 18 00 06 00 03 | 01 80 f6 00 15 11 00 1c |........|........|
|000016b0| 38 f1 b6 63 c7 81 83 e1 | f3 3e 1e 1e 36 cf 87 c0 |8..c....|.>..6...|
|000016c0| ff 00 13 08 00 1e 79 19 | c6 c6 63 01 83 fc 33 03 |......y.|..c...3.|
|000016d0| 38 cc cc c0 ff 00 13 08 | 00 17 d8 f9 87 86 63 01 |8.......|......c.|
|000016e0| e3 fc 33 03 30 cc cc c0 | ff 00 15 08 00 13 99 99 |..3.0...|........|
|000016f0| 87 07 e3 01 83 fe 33 05 | 3f 3f 30 cc cc c0 ff 00 |......3.|??0.....|
|00001700| 14 08 00 11 19 99 87 86 | 03 01 83 fe 33 fe 30 02 |........|....3.0.|
|00001710| cc cc c0 ff 00 98 00 14 | 01 06 00 68 01 2e 01 00 |........|...h....|
|00001720| 01 06 00 6a 01 2e 00 fc | 01 06 00 6a 01 2e 00 fc |...j....|...j....|
|00001730| 00 00 15 08 00 10 19 99 | 86 c6 23 01 83 fe 33 05 |........|..#...3.|
|00001740| 31 31 30 cc cc c0 ff 00 | 15 11 00 10 18 f9 86 63 |110.....|.......c|
|00001750| c1 81 f3 31 f3 33 1e 1e | 30 cc c7 c0 ff 00 0a f7 |...1.3..|0.......|
|00001760| 00 00 30 fb 00 00 c0 ff | 00 0c f8 00 01 02 30 fc |..0.....|......0.|
|00001770| 00 01 08 c0 ff 00 0c f8 | 00 01 01 e0 fc 00 01 07 |........|........|
|00001780| 80 ff 00 02 ed 00 02 ed | 00 02 ed 00 13 01 00 1e |........|........|
|00001790| fc 00 01 01 8c fe 00 05 | f0 03 07 87 8f c0 ff 00 |........|........|
|000017a0| 13 01 00 31 fc 00 0a 01 | 80 00 00 01 08 07 0c cc |...1....|........|
|000017b0| c0 c0 ff 00 15 11 00 30 | 1e 36 f8 78 d9 e3 cc 78 |.......0|.6.x...x|
|000017c0| f8 02 64 03 0c cc c0 c0 | ff 00 15 11 00 30 33 38 |..d.....|.....038|
|000017d0| cc cc e2 31 8c cc cc 02 | 94 03 0c cc c0 c0 ff 00 |...1....|........|
|000017e0| 15 11 00 30 33 30 cc cc | c1 f1 8c cc cc 02 84 03 |...030..|........|
|000017f0| 0c c7 81 80 ff 00 14 10 | 00 30 33 30 cc cc c3 31 |........|.030...1|
|00001800| 8c cc cc 02 94 03 07 cc | c3 fe 00 14 10 00 30 33 |........|......03|
|00001810| 30 cc cc c3 31 8c cc cc | 02 64 03 00 cc c3 fe 00 |0...1...|.d......|
|00001820| 14 10 00 31 33 30 cc cc | c3 31 8c cc cc 01 08 03 |...130..|.1......|
|00001830| 01 8c c3 fe 00 14 10 00 | 1e 1e 30 f8 78 c1 f0 cc |........|..0.x...|
|00001840| 78 cc 00 f0 03 07 07 83 | fe 00 06 fd 00 00 c0 f2 |x.......|........|
|00001850| 00 06 fd 00 00 c0 f2 00 | 02 ed 00 02 ed 00 02 ed |........|........|
|00001860| 00 02 ed 00 07 00 3f f0 | ff 01 e0 00 02 ed 00 02 |......?.|........|
|00001870| ed 00 02 ed 00 02 ed 00 | 0e 0a 00 07 c0 00 7c 03 |........|......|.|
|00001880| 00 06 66 00 60 f8 00 0c | 08 00 06 60 00 60 00 00 |..f.`...|...`.`..|
|00001890| 06 66 f6 00 14 10 00 06 | 66 60 60 db 1c 06 66 3c |.f......|f``...f<|
|000018a0| 63 87 1f f0 f1 f1 f0 fe | 00 14 07 00 06 66 60 60 |c.......|.....f``|
|000018b0| e3 32 06 fe 66 05 4c 99 | 99 19 99 98 fe 00 14 10 |.2..f.L.|........|
|000018c0| 00 07 c6 60 78 c3 30 06 | 66 66 67 0e 19 98 f9 99 |...`x.0.|ffg.....|
|000018d0| 98 fe 00 14 0c 00 06 66 | 60 60 c3 30 06 66 7e 63 |.......f|``.0.f~c|
|000018e0| 87 19 fe 99 00 98 fe 00 | 13 0b 00 06 66 60 60 c3 |........|....f``.|
|000018f0| 30 06 66 60 61 c3 fd 99 | 00 98 fe 00 13 0b 00 06 |0.f`a...|........|
|00001900| 66 60 60 c3 32 06 64 62 | 64 c9 fd 99 00 98 fe 00 |f``.2.db|d.......|
|00001910| 14 10 00 07 c3 e0 7c c3 | 1c 07 f8 3c 63 87 19 98 |......|.|...<c...|
|00001920| f9 99 98 fe 00 06 fe 00 | 00 60 f1 00 07 03 00 00 |........|.`......|
|00001930| 04 60 f1 00 07 03 00 00 | 03 c0 f1 00 98 00 14 01 |.`......|........|
|00001940| 2e 00 68 01 3e 01 00 01 | 2e 00 6a 01 3e 00 fc 01 |..h.>...|..j.>...|
|00001950| 2e 00 6a 01 3e 00 fc 00 | 00 02 ed 00 02 ed 00 02 |..j.>...|........|
|00001960| ed 00 02 ed 00 14 10 00 | 03 c0 00 7c 03 00 06 66 |........|...|...f|
|00001970| 00 60 00 00 01 80 18 0c | fe 00 11 08 00 06 60 00 |.`......|......`.|
|00001980| 60 00 00 06 66 fb 00 01 | 18 0c fe 00 14 10 00 06 |`...f...|........|
|00001990| 68 00 60 db 1c 06 66 3c | 67 c6 66 6d 8f 9f 1e fe |h.`...f<|g.fm....|
|000019a0| 00 14 09 00 03 08 00 60 | e3 32 06 66 46 fe 66 03 |.......`|.2.fF.f.|
|000019b0| 71 99 99 8c fe 00 14 09 | 00 06 70 00 78 c3 30 06 |q.......|..p.x.0.|
|000019c0| 66 3e fe 66 03 61 99 99 | 8c fe 00 12 07 00 06 60 |f>.f.a..|.......`|
|000019d0| 00 60 c3 30 06 fc 66 03 | 61 99 99 8c fe 00 12 07 |.`.0..f.|a.......|
|000019e0| 00 06 60 00 60 c3 30 06 | fc 66 03 61 99 99 8c fe |..`.`.0.|.f.a....|
|000019f0| 00 14 08 00 06 60 00 60 | c3 32 06 64 fe 66 04 64 |.....`.`|.2.d.f.d|
|00001a00| 61 99 99 8c fe 00 14 10 | 00 03 c0 00 7c c3 1c 07 |a.......|....|...|
|00001a10| f8 3e 66 67 f8 61 8f 99 | 86 fe 00 07 f3 00 01 01 |.>fg.a..|........|
|00001a20| 80 fd 00 07 f3 00 01 11 | 80 fd 00 06 f3 00 00 0f |........|........|
|00001a30| fc 00 ff 00 00 00 17 16 | 55 6e 6b 6e 6f 77 6e 20 |........|Unknown |
|00001a40| 65 72 72 6f 72 20 6d 65 | 73 73 61 67 65 2e 00 00 |error me|ssage...|
|00001a50| 00 44 43 20 20 54 68 69 | 73 20 69 73 20 61 20 46 |.DC  Thi|s is a F|
|00001a60| 61 74 61 6c 20 45 72 72 | 6f 72 20 2d 2d 20 43 61 |atal Err|or -- Ca|
|00001a70| 6c 6c 20 4d 61 72 6b 65 | 74 20 45 6e 67 69 6e 65 |ll Marke|t Engine|
|00001a80| 65 72 69 6e 67 2c 20 31 | 2d 33 30 33 2d 38 39 33 |ering, 1|-303-893|
|00001a90| 2d 30 31 30 30 2e 00 00 | 00 2c 2b 55 6e 61 62 6c |-0100...|.,+Unabl|
|00001aa0| 65 20 74 6f 20 64 69 73 | 70 6f 73 65 20 6f 66 20 |e to dis|pose of |
|00001ab0| 73 70 72 65 61 64 73 68 | 65 65 74 20 69 6e 20 6d |spreadsh|eet in m|
|00001ac0| 65 6d 6f 72 79 2e 00 00 | 00 37 36 4e 6f 74 20 65 |emory...|.76Not e|
|00001ad0| 6e 6f 75 67 68 20 6d 65 | 6d 6f 72 79 20 61 76 61 |nough me|mory ava|
|00001ae0| 69 6c 61 62 6c 65 20 74 | 6f 20 63 6f 6d 70 6c 65 |ilable t|o comple|
|00001af0| 74 65 20 74 68 65 20 6f | 70 65 72 61 74 69 6f 6e |te the o|peration|
|00001b00| 2e 00 00 00 1f 1e 54 6f | 6f 20 6d 61 6e 79 20 73 |......To|o many s|
|00001b10| 65 6c 65 63 74 69 6f 6e | 73 20 77 65 72 65 20 6d |election|s were m|
|00001b20| 61 64 65 2e 00 00 00 33 | 32 41 64 6a 75 73 74 61 |ade....3|2Adjusta|
|00001b30| 62 6c 65 20 63 65 6c 6c | 73 20 6d 75 73 74 20 6f |ble cell|s must o|
|00001b40| 6e 6c 79 20 63 6f 6e 74 | 61 69 6e 20 6e 75 6d 65 |nly cont|ain nume|
|00001b50| 72 69 63 20 76 61 6c 75 | 65 73 2e 00 00 00 2d 2c |ric valu|es....-,|
|00001b60| 43 6f 6e 73 74 72 61 69 | 6e 74 20 63 65 6c 6c 73 |Constrai|nt cells|
|00001b70| 20 6d 75 73 74 20 6f 6e | 6c 79 20 63 6f 6e 74 61 | must on|ly conta|
|00001b80| 69 6e 20 66 6f 72 6d 75 | 6c 61 73 2e 00 00 00 30 |in formu|las....0|
|00001b90| 2f 54 68 65 20 6f 62 6a | 65 63 74 69 76 65 20 63 |/The obj|ective c|
|00001ba0| 65 6c 6c 20 6d 75 73 74 | 20 6f 6e 6c 79 20 63 6f |ell must| only co|
|00001bb0| 6e 74 61 69 6e 20 61 20 | 66 6f 72 6d 75 6c 61 2e |ntain a |formula.|
|00001bc0| 00 00 00 35 34 54 68 65 | 20 63 65 6c 6c 20 79 6f |...54The| cell yo|
|00001bd0| 75 20 77 69 73 68 20 74 | 6f 20 6c 6f 63 61 74 65 |u wish t|o locate|
|00001be0| 20 69 73 20 6e 6f 74 20 | 6f 6e 20 74 68 65 20 77 | is not |on the w|
|00001bf0| 6f 72 6b 73 68 65 65 74 | 2e 00 00 00 34 33 54 68 |orksheet|....43Th|
|00001c00| 65 20 63 65 6c 6c 20 79 | 6f 75 20 77 69 73 68 20 |e cell y|ou wish |
|00001c10| 74 6f 20 6c 6f 63 61 74 | 65 20 6d 75 73 74 20 62 |to locat|e must b|
|00001c20| 65 20 69 6e 20 22 41 31 | 22 20 66 6f 72 6d 61 74 |e in "A1|" format|
|00001c30| 2e 00 00 00 14 13 4e 6f | 74 20 61 20 76 61 6c 69 |......No|t a vali|
|00001c40| 64 20 6e 75 6d 62 65 72 | 2e 00 00 00 23 22 4f 6e |d number|....#"On|
|00001c50| 6c 79 20 6e 75 6d 65 72 | 69 63 20 63 65 6c 6c 73 |ly numer|ic cells|
|00001c60| 20 6d 61 79 20 62 65 20 | 63 68 61 6e 67 65 64 2e | may be |changed.|
|00001c70| 00 00 00 3d 3c 43 6f 6e | 74 72 69 62 75 74 69 6f |...=<Con|tributio|
|00001c80| 6e 20 72 61 6e 67 65 73 | 20 61 72 65 20 6f 6e 6c |n ranges| are onl|
|00001c90| 79 20 61 76 61 69 6c 61 | 62 6c 65 20 66 6f 72 20 |y availa|ble for |
|00001ca0| 61 64 6a 75 73 74 61 62 | 6c 65 20 63 65 6c 6c 73 |adjustab|le cells|
|00001cb0| 2e 00 00 00 37 36 53 68 | 61 64 6f 77 20 70 72 69 |....76Sh|adow pri|
|00001cc0| 63 65 73 20 61 72 65 20 | 6f 6e 6c 79 20 61 76 61 |ces are |only ava|
|00001cd0| 69 6c 61 62 6c 65 20 66 | 6f 72 20 63 6f 6e 73 74 |ilable f|or const|
|00001ce0| 72 61 69 6e 74 20 63 65 | 6c 6c 73 2e 00 00 00 52 |raint ce|lls....R|
|00001cf0| 51 54 6f 6f 20 6d 61 6e | 79 20 61 64 6a 75 73 74 |QToo man|y adjust|
|00001d00| 61 62 6c 65 20 63 65 6c | 6c 73 20 77 65 72 65 20 |able cel|ls were |
|00001d10| 73 65 6c 65 63 74 65 64 | 2e 20 20 4c 69 6d 69 74 |selected|.  Limit|
|00001d20| 65 64 20 74 6f 20 35 20 | 63 65 6c 6c 73 20 69 6e |ed to 5 |cells in|
|00001d30| 20 74 68 65 20 64 65 6d | 6f 20 76 65 72 73 69 6f | the dem|o versio|
|00001d40| 6e 2e 00 00 00 52 51 54 | 6f 6f 20 6d 61 6e 79 20 |n....RQT|oo many |
|00001d50| 63 6f 6e 73 74 72 61 69 | 6e 74 20 63 65 6c 6c 73 |constrai|nt cells|
|00001d60| 20 77 65 72 65 20 73 65 | 6c 65 63 74 65 64 2e 20 | were se|lected. |
|00001d70| 20 4c 69 6d 69 74 65 64 | 20 74 6f 20 38 20 63 65 | Limited| to 8 ce|
|00001d80| 6c 6c 73 20 69 6e 20 74 | 68 65 20 64 65 6d 6f 20 |lls in t|he demo |
|00001d90| 76 65 72 73 69 6f 6e 2e | 00 00 00 41 40 54 6f 6f |version.|...A@Too|
|00001da0| 20 6d 61 6e 79 20 6f 62 | 6a 65 63 74 69 76 65 20 | many ob|jective |
|00001db0| 63 65 6c 6c 73 20 77 65 | 72 65 20 73 65 6c 65 63 |cells we|re selec|
|00001dc0| 74 65 64 2e 20 20 50 6c | 65 61 73 65 20 73 65 6c |ted.  Pl|ease sel|
|00001dd0| 65 63 74 20 6a 75 73 74 | 20 6f 6e 65 2e 00 00 00 |ect just| one....|
|00001de0| 1e 1d 4b 65 79 20 6e 75 | 6d 62 65 72 20 69 6e 20 |..Key nu|mber in |
|00001df0| 6d 61 74 72 69 78 20 69 | 73 20 7a 65 72 6f 2e 00 |matrix i|s zero..|
|00001e00| 00 00 33 32 54 68 65 20 | 6d 6f 64 65 6c 20 69 73 |..32The |model is|
|00001e10| 20 6e 6f 6e 2d 6c 69 6e | 65 61 72 20 61 6e 64 20 | non-lin|ear and |
|00001e20| 63 61 6e 27 74 20 62 65 | 20 6f 70 74 69 6d 69 7a |can't be| optimiz|
|00001e30| 65 64 2e 20 20 20 00 00 | 00 40 3f 54 68 65 20 6f |ed.   ..|.@?The o|
|00001e40| 62 6a 65 63 74 69 76 65 | 20 63 65 6c 6c 20 68 61 |bjective| cell ha|
|00001e50| 73 20 61 6c 73 6f 20 62 | 65 65 6e 20 73 65 6c 65 |s also b|een sele|
|00001e60| 63 74 65 64 20 61 73 20 | 61 20 63 6f 6e 73 74 72 |cted as |a constr|
|00001e70| 61 69 6e 74 20 63 65 6c | 6c 2e 00 00 00 30 2f 4f |aint cel|l....0/O|
|00001e80| 6e 65 20 6f 72 20 6d 6f | 72 65 20 61 64 6a 75 73 |ne or mo|re adjus|
|00001e90| 74 61 62 6c 65 20 63 65 | 6c 6c 73 20 61 72 65 20 |table ce|lls are |
|00001ea0| 75 6e 63 6f 6e 73 74 72 | 61 69 6e 65 64 2e 00 00 |unconstr|ained...|
|00001eb0| 00 3e 3d 41 20 66 6f 72 | 6d 75 6c 61 20 69 6e 20 |.>=A for|mula in |
|00001ec0| 74 68 65 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |the spre|adsheet |
|00001ed0| 72 65 66 65 72 73 20 74 | 6f 20 61 20 62 61 64 20 |refers t|o a bad |
|00001ee0| 6f 72 20 69 6e 76 61 6c | 69 64 20 63 65 6c 6c 2e |or inval|id cell.|
|00001ef0| 00 00 00 44 43 4e 6f 20 | 66 65 61 73 69 62 6c 65 |...DCNo |feasible|
|00001f00| 20 73 6f 6c 75 74 69 6f | 6e 20 65 78 69 73 74 73 | solutio|n exists|
|00001f10| 20 77 68 69 63 68 20 73 | 61 74 69 73 66 69 65 73 | which s|atisfies|
|00001f20| 20 61 6c 6c 20 6f 66 20 | 74 68 65 20 63 6f 6e 73 | all of |the cons|
|00001f30| 74 72 61 69 6e 74 73 2e | 00 00 00 29 28 54 68 65 |traints.|...)(The|
|00001f40| 20 73 6f 6c 75 74 69 6f | 6e 20 66 6f 72 20 74 68 | solutio|n for th|
|00001f50| 65 20 6d 6f 64 65 6c 20 | 69 73 20 75 6e 62 6f 75 |e model |is unbou|
|00001f60| 6e 64 65 64 2e 00 00 00 | 30 2f 55 6e 61 62 6c 65 |nded....|0/Unable|
|00001f70| 20 74 6f 20 72 65 61 64 | 20 73 70 72 65 61 64 73 | to read| spreads|
|00001f80| 68 65 65 74 2e 20 20 49 | 6e 76 61 6c 69 64 20 53 |heet.  I|nvalid S|
|00001f90| 59 4c 4b 20 66 69 6c 65 | 2e 00 00 00 3c 3b 55 6e |YLK file|....<;Un|
|00001fa0| 61 62 6c 65 20 74 6f 20 | 72 65 61 64 20 73 70 72 |able to |read spr|
|00001fb0| 65 61 64 73 68 65 65 74 | 2e 20 20 49 6e 76 61 6c |eadsheet|.  Inval|
|00001fc0| 69 64 20 53 59 4c 4b 20 | 70 61 72 6d 20 65 6e 63 |id SYLK |parm enc|
|00001fd0| 6f 75 6e 74 65 72 65 64 | 2e 00 00 00 41 40 55 6e |ountered|....A@Un|
|00001fe0| 61 62 6c 65 20 74 6f 20 | 72 65 61 64 20 73 70 72 |able to |read spr|
|00001ff0| 65 61 64 73 68 65 65 74 | 2e 20 20 49 6e 76 61 6c |eadsheet|.  Inval|
|00002000| 69 64 20 58 2c 59 20 63 | 6f 6f 72 64 69 6e 61 74 |id X,Y c|oordinat|
|00002010| 65 20 65 6e 63 6f 75 6e | 74 65 72 65 64 2e 00 00 |e encoun|tered...|
|00002020| 00 41 40 55 6e 61 62 6c | 65 20 74 6f 20 72 65 61 |.A@Unabl|e to rea|
|00002030| 64 20 73 70 72 65 61 64 | 73 68 65 65 74 2e 20 20 |d spread|sheet.  |
|00002040| 4e 6f 20 63 65 6c 6c 20 | 76 61 6c 75 65 20 66 6f |No cell |value fo|
|00002050| 6c 6c 6f 77 65 64 20 4b | 2d 53 59 4c 4b 20 70 61 |llowed K|-SYLK pa|
|00002060| 72 6d 2e 00 00 00 44 43 | 55 6e 61 62 6c 65 20 74 |rm....DC|Unable t|
|00002070| 6f 20 72 65 61 64 20 73 | 70 72 65 61 64 73 68 65 |o read s|preadshe|
|00002080| 65 74 2e 20 20 43 61 6e | 27 74 20 65 76 61 6c 75 |et.  Can|'t evalu|
|00002090| 61 74 65 20 66 6f 72 6d | 75 6c 61 20 69 6e 20 73 |ate form|ula in s|
|000020a0| 70 72 65 61 64 73 68 65 | 65 74 2e 00 00 00 37 36 |preadshe|et....76|
|000020b0| 55 6e 61 62 6c 65 20 74 | 6f 20 72 65 61 64 20 73 |Unable t|o read s|
|000020c0| 70 72 65 61 64 73 68 65 | 65 74 2e 20 20 42 6f 75 |preadshe|et.  Bou|
|000020d0| 6e 64 73 20 65 72 72 6f | 72 20 65 6e 63 6f 75 6e |nds erro|r encoun|
|000020e0| 74 65 72 65 64 2e 00 00 | 00 1c 1b 55 6e 61 62 6c |tered...|...Unabl|
|000020f0| 65 20 74 6f 20 72 65 61 | 64 20 73 70 72 65 61 64 |e to rea|d spread|
|00002100| 73 68 65 65 74 2e 00 00 | 00 36 35 55 6e 61 62 6c |sheet...|.65Unabl|
|00002110| 65 20 74 6f 20 72 65 61 | 64 20 73 70 72 65 61 64 |e to rea|d spread|
|00002120| 73 68 65 65 74 2e 20 20 | 43 61 6e 27 74 20 66 69 |sheet.  |Can't fi|
|00002130| 6e 64 20 6f 72 20 6f 70 | 65 6e 20 66 69 6c 65 2e |nd or op|en file.|
|00002140| 00 00 00 59 58 4e 75 6d | 62 65 72 20 6f 66 20 74 |...YXNum|ber of t|
|00002150| 65 78 74 20 63 65 6c 6c | 73 20 65 78 63 65 65 64 |ext cell|s exceed|
|00002160| 73 20 61 6c 6c 6f 77 61 | 62 6c 65 20 6c 69 6d 69 |s allowa|ble limi|
|00002170| 74 2e 20 20 54 72 79 20 | 72 65 6d 6f 76 69 6e 67 |t.  Try |removing|
|00002180| 20 74 65 78 74 20 63 65 | 6c 6c 73 20 66 72 6f 6d | text ce|lls from|
|00002190| 20 73 70 72 65 61 64 73 | 68 65 65 74 2e 00 00 00 | spreads|heet....|
|000021a0| 5b 5a 4e 75 6d 62 65 72 | 20 6f 66 20 6e 75 6d 65 |[ZNumber| of nume|
|000021b0| 72 69 63 20 63 65 6c 6c | 73 20 65 78 63 65 65 64 |ric cell|s exceed|
|000021c0| 73 20 61 6c 6c 6f 77 61 | 62 6c 65 20 6c 69 6d 69 |s allowa|ble limi|
|000021d0| 74 2e 20 20 54 72 79 20 | 6d 6f 76 69 6e 67 20 6e |t.  Try |moving n|
|000021e0| 75 6d 65 72 69 63 20 76 | 61 6c 75 65 73 20 69 6e |umeric v|alues in|
|000021f0| 74 6f 20 66 6f 72 6d 75 | 6c 61 73 2e 00 00 00 53 |to formu|las....S|
|00002200| 52 4e 75 6d 62 65 72 20 | 6f 66 20 66 6f 72 6d 75 |RNumber |of formu|
|00002210| 6c 61 73 20 65 78 63 65 | 65 64 73 20 61 6c 6c 6f |las exce|eds allo|
|00002220| 77 61 62 6c 65 20 6c 69 | 6d 69 74 2e 20 20 54 72 |wable li|mit.  Tr|
|00002230| 79 20 6f 70 74 69 6d 69 | 7a 69 6e 67 20 61 20 73 |y optimi|zing a s|
|00002240| 6d 61 6c 6c 65 72 20 73 | 70 72 65 61 64 73 68 65 |maller s|preadshe|
|00002250| 65 74 2e 00 00 00 83 82 | 4e 75 6d 62 65 72 20 6f |et......|Number o|
|00002260| 66 20 66 69 78 65 64 20 | 66 6f 72 6d 75 6c 61 73 |f fixed |formulas|
|00002270| 20 65 78 63 65 65 64 73 | 20 61 6c 6c 6f 77 61 62 | exceeds| allowab|
|00002280| 6c 65 20 6c 69 6d 69 74 | 2e 20 20 4d 61 6b 65 20 |le limit|.  Make |
|00002290| 73 75 72 65 20 61 6c 6c | 20 66 6f 72 6d 75 6c 61 |sure all| formula|
|000022a0| 73 20 75 73 65 20 73 74 | 61 6e 64 61 72 64 20 61 |s use st|andard a|
|000022b0| 6c 67 65 62 72 61 69 63 | 20 6f 70 65 72 61 74 69 |lgebraic| operati|
|000022c0| 6f 6e 73 20 28 2b 2c 20 | 2d 2c 20 2a 2c 20 2f 2c |ons (+, |-, *, /,|
|000022d0| 20 61 6e 64 20 53 55 4d | 29 2e 00 00 00 49 48 55 | and SUM|)....IHU|
|000022e0| 6e 61 62 6c 65 20 74 6f | 20 73 61 76 65 20 73 70 |nable to| save sp|
|000022f0| 72 65 61 64 73 68 65 65 | 74 2e 20 20 4e 6f 74 20 |readshee|t.  Not |
|00002300| 65 6e 6f 75 67 68 20 72 | 6f 6f 6d 20 6f 6e 20 64 |enough r|oom on d|
|00002310| 69 73 6b 20 66 6f 72 20 | 61 20 77 6f 72 6b 69 6e |isk for |a workin|
|00002320| 67 20 63 6f 70 79 2e 00 | 00 00 36 35 55 6e 61 62 |g copy..|..65Unab|
|00002330| 6c 65 20 74 6f 20 73 61 | 76 65 20 73 70 72 65 61 |le to sa|ve sprea|
|00002340| 64 73 68 65 65 74 2e 20 | 20 4e 6f 74 20 65 6e 6f |dsheet. | Not eno|
|00002350| 75 67 68 20 72 6f 6f 6d | 20 6f 6e 20 64 69 73 6b |ugh room| on disk|
|00002360| 2e 00 00 00 32 31 55 6e | 61 62 6c 65 20 74 6f 20 |....21Un|able to |
|00002370| 73 61 76 65 20 73 70 72 | 65 61 64 73 68 65 65 74 |save spr|eadsheet|
|00002380| 2e 20 20 43 61 6e 27 74 | 20 77 72 69 74 65 20 74 |.  Can't| write t|
|00002390| 6f 20 66 69 6c 65 2e 00 | 00 00 48 47 55 6e 61 62 |o file..|..HGUnab|
|000023a0| 6c 65 20 74 6f 20 73 61 | 76 65 20 73 70 72 65 61 |le to sa|ve sprea|
|000023b0| 64 73 68 65 65 74 2e 20 | 20 50 72 65 6d 61 74 75 |dsheet. | Prematu|
|000023c0| 72 65 20 65 6f 66 2d 6f | 66 2d 66 69 6c 65 20 65 |re eof-o|f-file e|
|000023d0| 6e 63 6f 75 6e 74 65 72 | 65 64 20 6f 6e 20 66 69 |ncounter|ed on fi|
|000023e0| 6c 65 2e 00 00 00 41 40 | 55 6e 61 62 6c 65 20 74 |le....A@|Unable t|
|000023f0| 6f 20 73 61 76 65 20 73 | 70 72 65 61 64 73 68 65 |o save s|preadshe|
|00002400| 65 74 2e 20 20 49 6e 76 | 61 6c 69 64 20 58 2c 59 |et.  Inv|alid X,Y|
|00002410| 20 63 6f 6f 72 64 69 6e | 61 74 65 20 65 6e 63 6f | coordin|ate enco|
|00002420| 75 6e 74 65 72 65 64 2e | 00 00 00 3c 3b 55 6e 61 |untered.|...<;Una|
|00002430| 62 6c 65 20 74 6f 20 73 | 61 76 65 20 73 70 72 65 |ble to s|ave spre|
|00002440| 61 64 73 68 65 65 74 2e | 20 20 49 6e 76 61 6c 69 |adsheet.|  Invali|
|00002450| 64 20 53 59 4c 4b 20 70 | 61 72 6d 20 65 6e 63 6f |d SYLK p|arm enco|
|00002460| 75 6e 74 65 72 65 64 2e | 00 00 00 35 34 55 6e 61 |untered.|...54Una|
|00002470| 62 6c 65 20 74 6f 20 73 | 61 76 65 20 73 70 72 65 |ble to s|ave spre|
|00002480| 61 64 73 68 65 65 74 2e | 20 20 43 75 72 72 65 6e |adsheet.|  Curren|
|00002490| 74 20 66 69 6c 65 20 6e | 6f 74 20 66 6f 75 6e 64 |t file n|ot found|
|000024a0| 2e 00 00 00 33 32 55 6e | 61 62 6c 65 20 74 6f 20 |....32Un|able to |
|000024b0| 73 61 76 65 20 73 70 72 | 65 61 64 73 68 65 65 74 |save spr|eadsheet|
|000024c0| 2e 20 20 43 75 72 72 65 | 6e 74 20 66 69 6c 65 20 |.  Curre|nt file |
|000024d0| 69 73 20 62 75 73 79 2e | 00 00 00 35 34 55 6e 61 |is busy.|...54Una|
|000024e0| 62 6c 65 20 74 6f 20 73 | 61 76 65 20 73 70 72 65 |ble to s|ave spre|
|000024f0| 61 64 73 68 65 65 74 2e | 20 20 46 69 6c 65 20 64 |adsheet.|  File d|
|00002500| 69 72 65 63 74 6f 72 79 | 20 69 73 20 66 75 6c 6c |irectory| is full|
|00002510| 2e 00 00 00 37 36 55 6e | 61 62 6c 65 20 74 6f 20 |....76Un|able to |
|00002520| 73 61 76 65 20 73 70 72 | 65 61 64 73 68 65 65 74 |save spr|eadsheet|
|00002530| 2e 20 20 4e 65 77 20 66 | 69 6c 65 20 6e 61 6d 65 |.  New f|ile name|
|00002540| 20 69 73 20 69 6e 76 61 | 6c 69 64 2e 00 00 00 35 | is inva|lid....5|
|00002550| 34 55 6e 61 62 6c 65 20 | 74 6f 20 73 61 76 65 20 |4Unable |to save |
|00002560| 73 70 72 65 61 64 73 68 | 65 65 74 2e 20 20 44 69 |spreadsh|eet.  Di|
|00002570| 73 6b 20 6f 72 20 66 69 | 6c 65 20 69 73 20 6c 6f |sk or fi|le is lo|
|00002580| 63 6b 65 64 2e 00 00 00 | 36 35 55 6e 61 62 6c 65 |cked....|65Unable|
|00002590| 20 74 6f 20 73 61 76 65 | 20 73 70 72 65 61 64 73 | to save| spreads|
|000025a0| 68 65 65 74 2e 20 20 55 | 6e 6b 6e 6f 77 6e 20 6f |heet.  U|nknown o|
|000025b0| 72 20 6d 69 73 73 69 6e | 67 20 64 69 73 6b 2e 00 |r missin|g disk..|
|000025c0| 00 00 34 33 55 6e 61 62 | 6c 65 20 74 6f 20 73 61 |..43Unab|le to sa|
|000025d0| 76 65 20 73 70 72 65 61 | 64 73 68 65 65 74 2e 20 |ve sprea|dsheet. |
|000025e0| 20 43 61 6e 27 74 20 72 | 65 6e 61 6d 65 20 6e 65 | Can't r|ename ne|
|000025f0| 77 20 66 69 6c 65 2e 00 | 00 00 3c 3b 55 6e 61 62 |w file..|..<;Unab|
|00002600| 6c 65 20 74 6f 20 65 76 | 61 6c 75 61 74 65 20 66 |le to ev|aluate f|
|00002610| 6f 72 6d 75 6c 61 2c 20 | 63 61 6e 74 20 64 65 2d |ormula, |cant de-|
|00002620| 62 6c 6f 63 6b 20 74 6f | 6b 65 6e 20 69 6e 20 66 |block to|ken in f|
|00002630| 6f 72 6d 75 6c 61 2e 00 | 00 00 3d 3c 46 6f 72 6d |ormula..|..=<Form|
|00002640| 75 6c 61 20 69 73 20 6e | 65 73 74 65 64 20 74 6f |ula is n|ested to|
|00002650| 6f 20 64 65 65 70 6c 79 | 2e 20 20 4d 61 78 69 6d |o deeply|.  Maxim|
|00002660| 75 6d 20 73 74 61 63 6b | 20 64 65 70 74 68 20 65 |um stack| depth e|
|00002670| 78 63 65 65 64 65 64 2e | 00 00 00 15 14 42 61 64 |xceeded.|.....Bad|
|00002680| 20 4f 74 68 65 72 77 69 | 73 65 20 54 61 6b 65 6e | Otherwi|se Taken|
|00002690| 2e 00 00 00 02 00 2b 00 | 00 00 02 00 1d 00 00 00 |......+.|........|
|000026a0| 02 00 09 00 00 00 02 00 | 0a 00 00 00 02 00 0b 00 |........|........|
|000026b0| 00 00 02 00 23 00 00 00 | 02 00 23 00 00 00 02 00 |....#...|..#.....|
|000026c0| 1b 00 00 00 02 00 1b 00 | 00 00 02 00 18 00 00 00 |........|........|
|000026d0| 02 00 17 00 00 00 02 00 | 09 00 00 00 02 00 0a 00 |........|........|
|000026e0| 00 00 02 00 0b 00 00 00 | 02 00 1a 00 00 00 02 00 |........|........|
|000026f0| 0b 00 00 00 02 00 09 00 | 00 00 02 00 2a 00 00 00 |........|....*...|
|00002700| 02 00 27 00 00 00 02 00 | 28 00 00 00 02 00 08 00 |..'.....|(.......|
|00002710| 00 00 02 00 08 00 00 00 | 02 00 08 00 00 00 02 00 |........|........|
|00002720| 08 00 00 00 02 00 08 00 | 00 00 02 00 08 00 00 00 |........|........|
|00002730| 02 00 08 00 00 00 02 00 | 2d 00 00 00 02 00 2d 00 |........|-.....-.|
|00002740| 00 00 02 00 2d 00 00 00 | 02 00 2d 00 00 00 02 00 |....-...|..-.....|
|00002750| 20 00 00 00 02 00 1f 00 | 00 00 02 00 2d 00 00 00 | .......|....-...|
|00002760| 02 00 2d 00 00 00 02 00 | 2d 00 00 00 02 00 2d 00 |..-.....|-.....-.|
|00002770| 00 00 02 00 20 00 00 00 | 02 00 20 00 00 00 02 00 |.... ...|.. .....|
|00002780| 20 00 00 00 02 00 2d 00 | 00 00 02 00 20 00 00 00 | .....-.|.... ...|
|00002790| 02 00 2d 00 00 00 02 00 | 2d 00 00 03 9f 00 2d 11 |..-.....|-.....-.|
|000027a0| 4f 72 64 65 72 20 49 6e | 66 6f 72 6d 61 74 69 6f |Order In|formatio|
|000027b0| 6e 0c 49 6e 74 72 6f 64 | 75 63 74 69 6f 6e 18 20 |n.Introd|uction. |
|000027c0| 20 20 57 68 61 74 20 69 | 73 20 42 65 73 74 20 41 |  What i|s Best A|
|000027d0| 6e 73 77 65 72 aa 3f 14 | 20 20 20 48 6f 77 20 44 |nswer.?.|   How D|
|000027e0| 6f 65 73 20 69 74 20 57 | 6f 72 6b 3f 12 20 20 20 |oes it W|ork?.   |
|000027f0| 41 20 46 65 77 20 4e 65 | 77 20 54 65 72 6d 73 0d |A Few Ne|w Terms.|
|00002800| 20 20 20 49 6e 20 53 75 | 6d 6d 61 72 79 0c 42 61 |   In Su|mmary.Ba|
|00002810| 73 69 63 20 54 6f 70 69 | 63 73 13 20 20 20 4c 6f |sic Topi|cs.   Lo|
|00002820| 61 64 20 53 70 72 65 61 | 64 73 68 65 65 74 20 20 |ad Sprea|dsheet  |
|00002830| 20 20 44 65 66 69 6e 69 | 6e 67 20 41 64 6a 75 73 |  Defini|ng Adjus|
|00002840| 74 61 62 6c 65 20 43 65 | 6c 6c 73 20 20 20 20 1c |table Ce|lls    .|
|00002850| 20 20 20 44 65 66 69 6e | 69 6e 67 20 43 6f 6e 73 |   Defin|ing Cons|
|00002860| 74 72 61 69 6e 74 20 43 | 65 6c 6c 73 1e 20 20 20 |traint C|ells.   |
|00002870| 44 65 66 69 6e 69 6e 67 | 20 74 68 65 20 4f 62 6a |Defining| the Obj|
|00002880| 65 63 74 69 76 65 20 43 | 65 6c 6c 0f 20 20 20 4f |ective C|ell.   O|
|00002890| 70 74 69 6d 69 7a 61 74 | 69 6f 6e 1b 20 20 20 53 |ptimizat|ion.   S|
|000028a0| 77 69 74 63 68 65 72 20 | 61 6e 64 20 4d 75 6c 74 |witcher |and Mult|
|000028b0| 69 66 69 6e 64 65 72 12 | 20 20 20 45 78 63 65 6c |ifinder.|   Excel|
|000028c0| 20 46 75 6e 63 74 69 6f | 6e 73 08 45 78 61 6d 70 | Functio|ns.Examp|
|000028d0| 6c 65 73 1a 20 20 20 31 | 29 20 50 72 6f 64 75 63 |les.   1|) Produc|
|000028e0| 74 20 4d 69 78 20 50 6c | 61 6e 6e 69 6e 67 0e 20 |t Mix Pl|anning. |
|000028f0| 20 20 32 29 20 42 6c 65 | 6e 64 69 6e 67 15 20 20 |  2) Ble|nding.  |
|00002900| 20 33 29 20 4d 65 64 69 | 61 20 53 65 6c 65 63 74 | 3) Medi|a Select|
|00002910| 69 6f 6e 18 20 20 20 34 | 29 20 43 61 73 68 20 46 |ion.   4|) Cash F|
|00002920| 6c 6f 77 20 41 6e 61 6c | 79 73 69 73 16 20 20 20 |low Anal|ysis.   |
|00002930| 35 29 20 53 74 61 66 66 | 20 53 63 68 65 64 75 6c |5) Staff| Schedul|
|00002940| 69 6e 67 1a 20 20 20 36 | 29 20 50 6f 72 74 66 6f |ing.   6|) Portfo|
|00002950| 6c 69 6f 20 53 65 6c 65 | 63 74 69 6f 6e 20 14 53 |lio Sele|ction .S|
|00002960| 65 6e 73 69 74 69 76 69 | 74 79 20 41 6e 61 6c 79 |ensitivi|ty Analy|
|00002970| 73 69 73 0f 20 20 20 53 | 68 61 64 6f 77 20 50 72 |sis.   S|hadow Pr|
|00002980| 69 63 65 15 20 20 20 43 | 6f 6e 74 72 69 62 75 74 |ice.   C|ontribut|
|00002990| 69 6f 6e 20 52 61 6e 67 | 65 0a 52 65 66 65 72 65 |ion Rang|e.Refere|
|000029a0| 6e 63 65 3a 0c 20 20 20 | 4c 69 6e 65 61 72 69 74 |nce:.   |Linearit|
|000029b0| 79 13 20 20 20 43 68 61 | 6e 67 69 6e 67 20 56 61 |y.   Cha|nging Va|
|000029c0| 6c 75 65 73 20 1f 20 20 | 20 4d 6f 72 65 20 41 62 |lues .  | More Ab|
|000029d0| 6f 75 74 20 43 6f 6e 73 | 74 72 61 69 6e 74 20 43 |out Cons|traint C|
|000029e0| 65 6c 6c 73 20 12 20 20 | 20 53 65 6c 65 63 74 69 |ells .  | Selecti|
|000029f0| 6e 67 20 43 65 6c 6c 73 | 08 20 20 20 4d 65 6e 75 |ng Cells|.   Menu|
|00002a00| 73 10 20 20 20 20 20 20 | 41 70 70 6c 65 20 4d 65 |s.      |Apple Me|
|00002a10| 6e 75 0f 20 20 20 20 20 | 20 46 69 6c 65 20 4d 65 |nu.     | File Me|
|00002a20| 6e 75 0f 20 20 20 20 20 | 20 45 64 69 74 20 4d 65 |nu.     | Edit Me|
|00002a30| 6e 75 11 20 20 20 20 20 | 20 46 6f 72 6d 61 74 20 |nu.     | Format |
|00002a40| 4d 65 6e 75 10 20 20 20 | 20 20 20 43 65 6c 6c 20 |Menu.   |   Cell |
|00002a50| 4d 65 6e 75 20 17 20 20 | 20 20 20 20 4f 70 74 69 |Menu .  |    Opti|
|00002a60| 6d 69 7a 61 74 69 6f 6e | 20 4d 65 6e 75 19 20 20 |mization| Menu.  |
|00002a70| 20 53 70 72 65 61 64 73 | 68 65 65 74 20 46 6f 72 | Spreads|heet For|
|00002a80| 6d 61 74 74 69 6e 67 18 | 20 20 20 45 72 72 6f 72 |matting.|   Error|
|00002a90| 73 20 61 6e 64 20 45 78 | 63 65 70 74 69 6f 6e 73 |s and Ex|ceptions|
|00002aa0| 13 20 20 20 20 20 20 49 | 6e 66 65 61 73 69 62 69 |.      I|nfeasibi|
|00002ab0| 6c 69 74 79 13 20 20 20 | 20 20 20 55 6e 62 6f 75 |lity.   |   Unbou|
|00002ac0| 6e 64 65 64 6e 65 73 73 | 1e 20 20 20 20 20 20 46 |ndedness|.      F|
|00002ad0| 69 78 65 64 20 46 6f 72 | 6d 75 6c 61 73 20 28 49 |ixed For|mulas (I|
|00002ae0| 74 61 6c 69 63 73 29 20 | 20 20 20 20 20 20 49 6e |talics) |      In|
|00002af0| 76 61 6c 69 64 20 6e 75 | 6d 62 65 72 73 20 28 4e |valid nu|mbers (N|
|00002b00| 41 4e 2c 20 49 4e 46 29 | 13 20 20 20 20 20 20 4f |AN, INF)|.      O|
|00002b10| 75 74 20 6f 66 20 4d 65 | 6d 6f 72 79 14 20 20 20 |ut of Me|mory.   |
|00002b20| 20 20 20 45 72 72 6f 72 | 20 4d 65 73 73 61 67 65 |   Error| Message|
|00002b30| 73 0a 20 20 20 53 75 70 | 70 6f 72 74 00 00 03 cc |s.   Sup|port....|
|00002b40| 00 19 3e 57 65 6c 63 6f | 6d 65 20 74 6f 20 74 68 |..>Welco|me to th|
|00002b50| 65 20 64 65 6d 6f 6e 73 | 74 72 61 74 69 6f 6e 20 |e demons|tration |
|00002b60| 76 65 72 73 69 6f 6e 20 | 6f 66 20 42 65 73 74 20 |version |of Best |
|00002b70| 41 6e 73 77 65 72 aa 2c | 20 61 20 62 72 65 61 6b |Answer.,| a break|
|00002b80| 2d 3d 74 68 72 6f 75 67 | 68 20 69 6e 20 64 65 63 |-=throug|h in dec|
|00002b90| 69 73 69 6f 6e 20 73 75 | 70 70 6f 72 74 20 66 6f |ision su|pport fo|
|00002ba0| 72 20 4d 69 63 72 6f 73 | 6f 66 74 a8 20 73 70 72 |r Micros|oft. spr|
|00002bb0| 65 61 64 73 68 65 65 74 | 20 75 73 65 72 73 2e 00 |eadsheet| users..|
|00002bc0| 3c 41 66 74 65 72 20 65 | 78 70 65 72 69 6d 65 6e |<After e|xperimen|
|00002bd0| 74 69 6e 67 20 77 69 74 | 68 20 74 68 69 73 20 6c |ting wit|h this l|
|00002be0| 69 6d 69 74 65 64 20 76 | 65 72 73 69 6f 6e 2c 20 |imited v|ersion, |
|00002bf0| 79 6f 75 20 6d 61 79 20 | 6f 72 64 65 72 1b 42 65 |you may |order.Be|
|00002c00| 73 74 20 41 6e 73 77 65 | 72 aa 20 62 79 20 63 6f |st Answe|r. by co|
|00002c10| 6e 74 61 63 74 69 6e 67 | 3a 00 29 20 20 20 20 20 |ntacting|:.)     |
|00002c20| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002c30| 20 20 20 20 20 48 65 69 | 7a 65 72 20 53 6f 66 74 |     Hei|zer Soft|
|00002c40| 77 61 72 65 36 20 20 20 | 20 20 20 20 20 20 20 20 |ware6   |        |
|00002c50| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 31 |        |       1|
|00002c60| 39 34 31 20 4f 61 6b 20 | 50 61 72 6b 20 42 6c 76 |941 Oak |Park Blv|
|00002c70| 64 2c 20 53 75 69 74 65 | 20 33 30 31 20 20 20 20 |d, Suite| 301    |
|00002c80| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002c90| 20 20 20 20 20 20 50 6c | 65 61 73 61 6e 74 20 48 |      Pl|easant H|
|00002ca0| 69 6c 6c 2c 20 43 41 20 | 39 34 35 32 33 12 20 20 |ill, CA |94523.  |
|00002cb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002cc0| 31 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |1       |        |
|00002cd0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00002ce0| 20 20 2d 2d 20 6f 72 20 | 62 79 20 63 61 6c 6c 69 |  -- or |by calli|
|00002cf0| 6e 67 00 3f 20 20 20 20 | 20 20 20 20 20 20 20 20 |ng.?    |        |
|00002d00| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 31 2d |        |      1-|
|00002d10| 38 30 30 2d 32 32 35 2d | 36 37 35 35 20 20 20 28 |800-225-|6755   (|
|00002d20| 6f 75 74 73 69 64 65 20 | 43 61 6c 69 66 6f 72 6e |outside |Californ|
|00002d30| 69 61 29 3e 20 20 20 20 | 20 20 20 20 20 20 20 20 |ia)>    |        |
|00002d40| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 31 2d |        |      1-|
|00002d50| 34 31 35 2d 39 34 33 2d | 37 36 36 37 20 20 20 28 |415-943-|7667   (|
|00002d60| 69 6e 73 69 64 65 20 43 | 61 6c 69 66 6f 72 6e 69 |inside C|aliforni|
|00002d70| 61 29 0f 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |a).     |        |
|00002d80| 20 20 3a 46 6f 72 20 74 | 68 65 20 4d 69 63 72 6f |  :For t|he Micro|
|00002d90| 73 6f 66 74 a8 20 45 78 | 63 65 6c 20 76 65 72 73 |soft. Ex|cel vers|
|00002da0| 69 6f 6e 2c 20 20 61 73 | 6b 20 66 6f 72 20 70 72 |ion,  as|k for pr|
|00002db0| 6f 67 72 61 6d 20 23 31 | 30 34 35 32 2e 39 46 6f |ogram #1|0452.9Fo|
|00002dc0| 72 20 74 68 65 20 4d 69 | 63 72 6f 73 6f 66 74 a8 |r the Mi|crosoft.|
|00002dd0| 20 57 6f 72 6b 73 20 76 | 65 72 73 69 6f 6e 2c 20 | Works v|ersion, |
|00002de0| 61 73 6b 20 66 6f 72 20 | 70 72 6f 67 72 61 6d 20 |ask for |program |
|00002df0| 23 32 30 31 39 32 2e 00 | 2b 42 65 73 74 20 41 6e |#20192..|+Best An|
|00002e00| 73 77 65 72 aa 27 73 20 | 72 65 74 61 69 6c 20 70 |swer.'s |retail p|
|00002e10| 72 69 63 65 20 69 73 20 | 6f 6e 6c 79 20 24 39 39 |rice is |only $99|
|00002e20| 2e 30 30 2e 00 41 49 6e | 20 61 64 64 69 74 69 6f |.00..AIn| additio|
|00002e30| 6e 20 74 6f 20 64 69 73 | 74 72 69 62 75 74 69 6e |n to dis|tributin|
|00002e40| 67 20 42 65 73 74 20 41 | 6e 73 77 65 72 aa 2c 20 |g Best A|nswer., |
|00002e50| 48 65 69 7a 65 72 20 53 | 6f 66 74 77 61 72 65 20 |Heizer S|oftware |
|00002e60| 61 63 74 73 20 61 73 42 | 61 20 63 6c 65 61 72 69 |acts asB|a cleari|
|00002e70| 6e 67 20 68 6f 75 73 65 | 20 66 6f 72 20 6d 6f 72 |ng house| for mor|
|00002e80| 65 20 74 68 61 6e 20 37 | 30 30 20 74 65 6d 70 6c |e than 7|00 templ|
|00002e90| 61 74 65 73 2c 20 74 75 | 74 6f 72 69 61 6c 73 2c |ates, tu|torials,|
|00002ea0| 20 61 6e 64 20 64 61 74 | 61 2d 26 62 61 73 65 73 | and dat|a-&bases|
|00002eb0| 20 66 6f 72 20 45 78 63 | 65 6c 2c 20 57 6f 72 6b | for Exc|el, Work|
|00002ec0| 73 2c 20 61 6e 64 20 48 | 79 70 65 72 63 61 72 64 |s, and H|ypercard|
|00002ed0| 2e 00 39 43 6c 69 63 6b | 20 74 68 65 20 4e 45 58 |..9Click| the NEX|
|00002ee0| 54 20 62 75 74 74 6f 6e | 20 74 6f 20 70 72 6f 63 |T button| to proc|
|00002ef0| 65 65 64 20 74 6f 20 74 | 68 65 20 6f 6e 2d 6c 69 |eed to t|he on-li|
|00002f00| 6e 65 20 74 75 74 6f 72 | 69 61 6c 2e 00 00 05 62 |ne tutor|ial....b|
|00002f10| 00 1c 3f 42 65 73 74 20 | 41 6e 73 77 65 72 aa 20 |..?Best |Answer. |
|00002f20| 69 73 20 61 6e 20 22 61 | 64 64 2d 6f 6e 22 20 74 |is an "a|dd-on" t|
|00002f30| 6f 20 4d 69 63 72 6f 73 | 6f 66 74 a8 20 45 78 63 |o Micros|oft. Exc|
|00002f40| 65 6c 2e 20 20 53 69 6e | 63 65 20 79 6f 75 20 61 |el.  Sin|ce you a|
|00002f50| 72 65 43 61 6c 72 65 61 | 64 79 20 66 61 6d 69 6c |reCalrea|dy famil|
|00002f60| 69 61 72 20 77 69 74 68 | 20 45 78 63 65 6c 20 79 |iar with| Excel y|
|00002f70| 6f 75 20 72 65 61 6c 6c | 79 20 68 61 76 65 20 76 |ou reall|y have v|
|00002f80| 65 72 79 20 6c 69 74 74 | 6c 65 20 74 6f 20 6c 65 |ery litt|le to le|
|00002f90| 61 72 6e 2e 20 20 42 59 | 6f 75 20 73 69 6d 70 6c |arn.  BY|ou simpl|
|00002fa0| 79 20 63 72 65 61 74 65 | 20 79 6f 75 72 20 73 70 |y create| your sp|
|00002fb0| 72 65 61 64 73 68 65 65 | 74 20 69 6e 20 45 78 63 |readshee|t in Exc|
|00002fc0| 65 6c 20 28 6c 69 6b 65 | 20 79 6f 75 20 75 73 75 |el (like| you usu|
|00002fd0| 61 6c 6c 79 20 64 6f 29 | 2c 41 74 68 65 6e 20 6c |ally do)|,Athen l|
|00002fe0| 6f 61 64 20 69 74 20 69 | 6e 74 6f 20 42 65 73 74 |oad it i|nto Best|
|00002ff0| 20 41 6e 73 77 65 72 aa | 2c 20 77 68 69 63 68 20 | Answer.|, which |
|00003000| 77 69 6c 6c 20 68 65 6c | 70 20 79 6f 75 20 61 72 |will hel|p you ar|
|00003010| 72 69 76 65 20 61 74 20 | 74 68 65 39 62 65 73 74 |rive at |the9best|
|00003020| 20 70 6f 73 73 69 62 6c | 65 20 61 6e 73 77 65 72 | possibl|e answer|
|00003030| 20 66 6f 72 20 79 6f 75 | 72 20 63 75 72 72 65 6e | for you|r curren|
|00003040| 74 20 62 75 73 69 6e 65 | 73 73 20 73 69 74 75 61 |t busine|ss situa|
|00003050| 74 69 6f 6e 2e 00 42 59 | 6f 75 20 64 6f 6e 27 74 |tion..BY|ou don't|
|00003060| 20 6e 65 65 64 20 61 20 | 63 6f 6d 70 6c 69 63 61 | need a |complica|
|00003070| 74 65 64 20 6d 61 6e 75 | 61 6c 21 20 20 41 63 74 |ted manu|al!  Act|
|00003080| 75 61 6c 6c 79 2c 20 79 | 6f 75 20 61 6c 72 65 61 |ually, y|ou alrea|
|00003090| 64 79 20 6b 6e 6f 77 20 | 61 3e 6c 6f 74 20 61 62 |dy know |a>lot ab|
|000030a0| 6f 75 74 20 68 6f 77 20 | 42 65 73 74 20 41 6e 73 |out how |Best Ans|
|000030b0| 77 65 72 aa 20 77 6f 72 | 6b 73 20 62 65 63 61 75 |wer. wor|ks becau|
|000030c0| 73 65 20 69 74 20 69 73 | 20 62 61 73 65 64 20 6f |se it is| based o|
|000030d0| 6e 20 45 78 63 65 6c 2e | 41 54 68 65 72 65 20 61 |n Excel.|AThere a|
|000030e0| 72 65 20 61 20 66 65 77 | 20 6e 65 77 20 66 75 6e |re a few| new fun|
|000030f0| 63 74 69 6f 6e 73 20 79 | 6f 75 20 77 69 6c 6c 20 |ctions y|ou will |
|00003100| 6e 65 65 64 20 74 6f 20 | 6c 65 61 72 6e 2e 20 20 |need to |learn.  |
|00003110| 46 6f 6c 6c 6f 77 20 74 | 68 65 3f 73 74 65 70 73 |Follow t|he?steps|
|00003120| 20 62 65 6c 6f 77 20 74 | 6f 20 66 61 6d 69 6c 69 | below t|o famili|
|00003130| 61 72 69 7a 65 20 79 6f | 75 72 73 65 6c 66 20 77 |arize yo|urself w|
|00003140| 69 74 68 20 68 6f 77 20 | 74 68 65 20 70 72 6f 67 |ith how |the prog|
|00003150| 72 61 6d 20 77 6f 72 6b | 73 3a 00 43 20 20 20 31 |ram work|s:.C   1|
|00003160| 29 20 20 46 69 72 73 74 | 2c 20 72 65 61 64 20 74 |)  First|, read t|
|00003170| 68 65 20 72 65 73 74 20 | 6f 66 20 74 68 65 20 49 |he rest |of the I|
|00003180| 4e 54 52 4f 44 55 43 54 | 49 4f 4e 20 73 65 63 74 |NTRODUCT|ION sect|
|00003190| 69 6f 6e 2e 20 20 54 68 | 69 73 20 77 69 6c 6c 43 |ion.  Th|is willC|
|000031a0| 20 20 20 20 20 20 20 20 | 20 67 69 76 65 20 79 6f |        | give yo|
|000031b0| 75 20 61 6e 20 6f 76 65 | 72 76 69 65 77 20 6f 66 |u an ove|rview of|
|000031c0| 20 42 65 73 74 20 41 6e | 73 77 65 72 aa 2e 20 20 | Best An|swer..  |
|000031d0| 49 74 20 77 69 6c 6c 20 | 65 78 70 6c 61 69 6e 20 |It will |explain |
|000031e0| 74 68 65 3a 20 20 20 20 | 20 20 20 20 20 62 61 73 |the:    |     bas|
|000031f0| 69 63 73 20 6f 66 20 74 | 68 65 20 70 72 6f 67 72 |ics of t|he progr|
|00003200| 61 6d 20 61 6e 64 20 64 | 65 66 69 6e 65 20 61 20 |am and d|efine a |
|00003210| 66 65 77 20 6e 65 77 20 | 74 65 72 6d 73 2e 05 20 |few new |terms.. |
|00003220| 20 20 20 20 3f 20 20 20 | 20 32 29 20 20 4e 65 78 |    ?   | 2)  Nex|
|00003230| 74 2c 20 72 65 61 64 20 | 74 68 72 6f 75 67 68 20 |t, read |through |
|00003240| 74 68 65 20 42 41 53 49 | 43 20 54 4f 50 49 43 53 |the BASI|C TOPICS|
|00003250| 20 73 65 63 74 69 6f 6e | 20 6f 66 20 74 68 65 20 | section| of the |
|00003260| 48 45 4c 50 40 20 20 20 | 20 20 20 20 20 20 20 6d |HELP@   |       m|
|00003270| 65 6e 75 20 74 6f 20 66 | 75 72 74 68 65 72 20 66 |enu to f|urther f|
|00003280| 61 6d 69 6c 69 61 72 69 | 7a 65 20 79 6f 75 72 73 |amiliari|ze yours|
|00003290| 65 6c 66 20 77 69 74 68 | 20 74 68 65 20 70 72 6f |elf with| the pro|
|000032a0| 67 72 61 6d 2e 05 20 20 | 20 20 20 3e 20 20 20 33 |gram..  |   >   3|
|000032b0| 29 20 20 54 68 65 6e 2c | 20 67 6f 20 74 68 72 6f |)  Then,| go thro|
|000032c0| 75 67 68 20 61 20 66 65 | 77 20 45 58 41 4d 50 4c |ugh a fe|w EXAMPL|
|000032d0| 45 53 20 74 6f 20 67 65 | 74 20 73 6f 6d 65 20 22 |ES to ge|t some "|
|000032e0| 68 61 6e 64 73 2d 6f 6e | 22 20 47 20 20 20 20 20 |hands-on|" G     |
|000032f0| 20 20 20 20 20 65 78 70 | 65 72 69 65 6e 63 65 2e |     exp|erience.|
|00003300| 20 20 54 68 69 73 20 77 | 69 6c 6c 20 67 69 76 65 |  This w|ill give|
|00003310| 20 79 6f 75 20 61 6e 20 | 69 64 65 61 20 6f 66 20 | you an |idea of |
|00003320| 74 68 65 20 6d 61 6e 79 | 20 64 69 66 66 65 72 65 |the many| differe|
|00003330| 6e 74 36 20 20 20 20 20 | 20 20 20 20 20 74 79 70 |nt6     |     typ|
|00003340| 65 73 20 6f 66 20 73 69 | 74 75 61 74 69 6f 6e 73 |es of si|tuations|
|00003350| 20 42 65 73 74 20 41 6e | 73 77 65 72 aa 20 63 61 | Best An|swer. ca|
|00003360| 6e 20 68 61 6e 64 6c 65 | 2e 00 3c 4e 6f 74 65 3a |n handle|..<Note:|
|00003370| 20 20 42 65 73 74 20 41 | 6e 73 77 65 72 aa 20 69 |  Best A|nswer. i|
|00003380| 73 20 61 6c 73 6f 20 63 | 6f 6d 70 61 74 69 62 6c |s also c|ompatibl|
|00003390| 65 20 77 69 74 68 20 4d | 69 63 72 6f 73 6f 66 74 |e with M|icrosoft|
|000033a0| a8 20 57 6f 72 6b 73 29 | 20 20 20 20 20 20 20 20 |. Works)|        |
|000033b0| 20 20 20 61 6e 64 20 4d | 69 63 72 6f 73 6f 66 74 |   and M|icrosoft|
|000033c0| a8 20 4d 75 6c 74 69 70 | 6c 61 6e 2e 20 20 20 20 |. Multip|lan.    |
|000033d0| 20 05 20 20 20 20 20 3b | 4e 4f 57 20 2d 2d 20 50 | .     ;|NOW -- P|
|000033e0| 72 6f 63 65 65 64 20 77 | 69 74 68 20 74 68 65 20 |roceed w|ith the |
|000033f0| 49 4e 54 52 4f 44 55 43 | 54 49 4f 4e 20 62 79 20 |INTRODUC|TION by |
|00003400| 63 6c 69 63 6b 69 6e 67 | 20 74 68 65 20 22 4e 65 |clicking| the "Ne|
|00003410| 78 74 22 45 20 20 20 20 | 20 20 20 20 20 20 20 20 |xt"E    |        |
|00003420| 20 20 62 75 74 74 6f 6e | 20 61 74 20 74 68 65 20 |  button| at the |
|00003430| 62 6f 74 74 6f 6d 20 6f | 66 20 74 68 65 20 73 63 |bottom o|f the sc|
|00003440| 72 65 65 6e 20 28 6f 72 | 20 70 72 65 73 73 20 22 |reen (or| press "|
|00003450| 4e 22 20 6f 6e 20 74 68 | 65 18 20 20 20 20 20 20 |N" on th|e.      |
|00003460| 20 20 20 20 20 20 20 20 | 6b 65 79 62 6f 61 72 64 |        |keyboard|
|00003470| 29 2e 00 00 03 9d 00 13 | 3b 42 65 73 74 20 41 6e |).......|;Best An|
|00003480| 73 77 65 72 aa 20 69 73 | 20 61 6e 20 4f 50 54 49 |swer. is| an OPTI|
|00003490| 4d 49 5a 41 54 49 4f 4e | 20 70 72 6f 67 72 61 6d |MIZATION| program|
|000034a0| 2e 20 20 49 74 20 61 6c | 6c 6f 77 73 20 79 6f 75 |.  It al|lows you|
|000034b0| 20 74 6f 20 3b 4f 50 54 | 49 4d 49 5a 45 20 28 6d | to ;OPT|IMIZE (m|
|000034c0| 61 78 69 6d 69 7a 65 20 | 6f 72 20 6d 69 6e 69 6d |aximize |or minim|
|000034d0| 69 7a 65 29 20 61 20 67 | 69 76 65 6e 20 62 75 73 |ize) a g|iven bus|
|000034e0| 69 6e 65 73 73 20 73 69 | 74 75 61 74 69 6f 6e 2e |iness si|tuation.|
|000034f0| 3f 54 68 69 73 20 6d 61 | 79 20 62 65 20 74 6f 20 |?This ma|y be to |
|00003500| 6d 61 78 69 6d 69 7a 65 | 20 79 6f 75 72 20 70 72 |maximize| your pr|
|00003510| 6f 66 69 74 73 20 6f 72 | 20 74 6f 20 6d 69 6e 69 |ofits or| to mini|
|00003520| 6d 69 7a 65 20 79 6f 75 | 72 20 63 6f 73 74 73 2e |mize you|r costs.|
|00003530| 00 41 42 65 73 74 20 41 | 6e 73 77 65 72 aa 20 68 |.ABest A|nswer. h|
|00003540| 65 6c 70 73 20 79 6f 75 | 20 61 6e 61 6c 79 7a 65 |elps you| analyze|
|00003550| 20 79 6f 75 72 20 73 69 | 74 75 61 74 69 6f 6e 20 | your si|tuation |
|00003560| 73 6f 20 74 68 61 74 20 | 79 6f 75 20 63 61 6e 20 |so that |you can |
|00003570| 67 65 74 3e 74 68 65 20 | 62 65 73 74 20 72 65 73 |get>the |best res|
|00003580| 75 6c 74 73 20 77 69 74 | 68 6f 75 74 20 68 61 76 |ults wit|hout hav|
|00003590| 69 6e 67 20 74 6f 20 6d | 61 6e 69 70 75 6c 61 74 |ing to m|anipulat|
|000035a0| 65 20 6c 61 72 67 65 20 | 6e 75 6d 62 65 72 73 20 |e large |numbers |
|000035b0| 6f 66 3e 76 61 72 69 61 | 62 6c 65 73 20 28 41 44 |of>varia|bles (AD|
|000035c0| 4a 55 53 54 41 42 4c 45 | 53 29 20 62 79 20 68 61 |JUSTABLE|S) by ha|
|000035d0| 6e 64 2e 20 20 49 6e 20 | 6d 61 6b 69 6e 67 20 62 |nd.  In |making b|
|000035e0| 75 73 69 6e 65 73 73 20 | 64 65 63 69 73 69 6f 6e |usiness |decision|
|000035f0| 73 45 79 6f 75 20 64 6f | 20 74 68 69 73 20 61 6c |sEyou do| this al|
|00003600| 6c 20 74 68 65 20 74 69 | 6d 65 2e 20 20 4e 6f 74 |l the ti|me.  Not|
|00003610| 20 6f 6e 6c 79 20 69 73 | 20 74 68 69 73 20 22 57 | only is| this "W|
|00003620| 68 61 74 20 69 66 2e 2e | 2e 22 20 70 72 6f 63 65 |hat if..|." proce|
|00003630| 73 73 20 74 69 6d 65 40 | 63 6f 6e 73 75 6d 69 6e |ss time@|consumin|
|00003640| 67 2c 20 62 75 74 20 79 | 6f 75 20 61 72 65 20 6e |g, but y|ou are n|
|00003650| 65 76 65 72 20 71 75 69 | 74 65 20 73 75 72 65 20 |ever qui|te sure |
|00003660| 77 68 65 6e 20 79 6f 75 | 20 68 61 76 65 20 61 72 |when you| have ar|
|00003670| 72 69 76 65 64 20 61 74 | 1c 74 68 65 20 22 62 65 |rived at|.the "be|
|00003680| 73 74 20 70 6f 73 73 69 | 62 6c 65 20 61 6e 73 77 |st possi|ble answ|
|00003690| 65 72 22 2e 20 00 39 42 | 65 73 74 20 41 6e 73 77 |er". .9B|est Answ|
|000036a0| 65 72 aa 20 75 73 65 73 | 20 61 20 6d 61 74 68 65 |er. uses| a mathe|
|000036b0| 6d 61 74 69 63 61 6c 20 | 74 65 63 68 6e 69 71 75 |matical |techniqu|
|000036c0| 65 20 63 61 6c 6c 65 64 | 20 22 6c 69 6e 65 61 72 |e called| "linear|
|000036d0| 3d 70 72 6f 67 72 61 6d | 6d 69 6e 67 22 20 74 6f |=program|ming" to|
|000036e0| 20 64 65 74 65 72 6d 69 | 6e 65 20 74 68 65 20 63 | determi|ne the c|
|000036f0| 6f 6d 62 69 6e 61 74 69 | 6f 6e 20 6f 66 20 76 61 |ombinati|on of va|
|00003700| 6c 75 65 73 20 74 68 61 | 74 20 77 69 6c 6c 19 70 |lues tha|t will.p|
|00003710| 72 6f 64 75 63 65 20 74 | 68 65 20 62 65 73 74 20 |roduce t|he best |
|00003720| 72 65 73 75 6c 74 73 2e | 00 3d 42 65 73 74 20 41 |results.|.=Best A|
|00003730| 6e 73 77 65 72 aa 20 77 | 69 6c 6c 20 2d 2d 20 6d |nswer. w|ill -- m|
|00003740| 61 6e 69 70 75 6c 61 74 | 65 20 74 68 65 20 41 44 |anipulat|e the AD|
|00003750| 4a 55 53 54 41 42 4c 45 | 53 20 28 65 2e 67 2e 20 |JUSTABLE|S (e.g. |
|00003760| 76 61 72 79 69 6e 67 3d | 6c 65 76 65 6c 73 20 6f |varying=|levels o|
|00003770| 66 20 70 72 6f 64 75 63 | 74 69 6f 6e 29 20 77 69 |f produc|tion) wi|
|00003780| 74 68 69 6e 20 74 68 65 | 20 67 69 76 65 6e 20 43 |thin the| given C|
|00003790| 4f 4e 53 54 52 41 49 4e | 54 53 20 28 65 2e 67 2e |ONSTRAIN|TS (e.g.|
|000037a0| 20 74 69 6d 65 3e 6c 69 | 6d 69 74 73 20 6f 72 20 | time>li|mits or |
|000037b0| 63 75 72 72 65 6e 74 20 | 69 6e 76 65 6e 74 6f 72 |current |inventor|
|000037c0| 79 20 6c 65 76 65 6c 73 | 29 20 74 6f 20 4f 50 54 |y levels|) to OPT|
|000037d0| 49 4d 49 5a 45 20 79 6f | 75 72 20 4f 42 4a 45 43 |IMIZE yo|ur OBJEC|
|000037e0| 54 49 56 45 2e 28 75 73 | 75 61 6c 6c 79 20 74 6f |TIVE.(us|ually to|
|000037f0| 20 6d 61 78 69 6d 69 7a | 65 20 70 72 6f 66 69 74 | maximiz|e profit|
|00003800| 20 6f 72 20 6d 69 6e 69 | 6d 69 7a 65 20 63 6f 73 | or mini|mize cos|
|00003810| 74 29 2e 00 00 03 02 00 | 17 0b 59 6f 75 20 73 69 |t)......|..You si|
|00003820| 6d 70 6c 79 3a 00 3e 20 | 20 20 31 29 20 20 43 72 |mply:.> |  1)  Cr|
|00003830| 65 61 74 65 20 79 6f 75 | 72 20 73 70 72 65 61 64 |eate you|r spread|
|00003840| 73 68 65 65 74 20 69 6e | 20 45 78 63 65 6c 20 28 |sheet in| Excel (|
|00003850| 6c 69 6b 65 20 79 6f 75 | 20 75 73 75 61 6c 6c 79 |like you| usually|
|00003860| 20 64 6f 29 2e 00 2c 20 | 20 20 32 29 20 20 53 61 | do).., |  2)  Sa|
|00003870| 76 65 20 79 6f 75 72 20 | 73 70 72 65 61 64 73 68 |ve your |spreadsh|
|00003880| 65 65 74 20 61 73 20 61 | 20 53 59 4c 4b 20 66 69 |eet as a| SYLK fi|
|00003890| 6c 65 2e 00 2e 20 20 20 | 33 29 20 20 4c 6f 61 64 |le...   |3)  Load|
|000038a0| 20 74 68 65 20 73 70 72 | 65 61 64 73 68 65 65 74 | the spr|eadsheet|
|000038b0| 20 69 6e 74 6f 20 42 65 | 73 74 20 41 6e 73 77 65 | into Be|st Answe|
|000038c0| 72 aa 2e 00 3a 20 20 20 | 34 29 20 20 53 65 74 20 |r...:   |4)  Set |
|000038d0| 75 70 20 74 68 65 20 70 | 72 6f 62 6c 65 6d 20 66 |up the p|roblem f|
|000038e0| 6f 72 20 42 65 73 74 20 | 41 6e 73 77 65 72 aa 20 |or Best |Answer. |
|000038f0| 62 79 20 64 65 66 69 6e | 69 6e 67 20 74 68 65 42 |by defin|ing theB|
|00003900| 20 20 20 20 20 20 20 20 | 20 20 61 70 70 72 6f 70 |        |  approp|
|00003910| 72 69 61 74 65 20 63 65 | 6c 6c 73 3a 20 20 41 44 |riate ce|lls:  AD|
|00003920| 4a 55 53 54 41 42 4c 45 | 20 63 65 6c 6c 73 2c 20 |JUSTABLE| cells, |
|00003930| 43 4f 4e 53 54 52 41 49 | 4e 54 20 63 65 6c 6c 73 |CONSTRAI|NT cells|
|00003940| 2c 20 21 20 20 20 20 20 | 20 20 20 20 20 61 6e 64 |, !     |     and|
|00003950| 20 74 68 65 20 4f 42 4a | 45 43 54 49 56 45 20 63 | the OBJ|ECTIVE c|
|00003960| 65 6c 6c 2e 05 20 20 20 | 20 20 3d 20 20 20 35 29 |ell..   |  =   5)|
|00003970| 20 20 4f 50 54 49 4d 49 | 5a 45 20 28 65 69 74 68 |  OPTIMI|ZE (eith|
|00003980| 65 72 20 6d 61 78 69 6d | 69 7a 65 20 6f 72 20 6d |er maxim|ize or m|
|00003990| 69 6e 69 6d 69 7a 65 29 | 20 79 6f 75 72 20 4f 42 |inimize)| your OB|
|000039a0| 4a 45 43 54 49 56 45 2e | 00 44 20 20 20 36 29 20 |JECTIVE.|.D   6) |
|000039b0| 20 53 61 76 65 20 74 68 | 65 20 6f 70 74 69 6d 69 | Save th|e optimi|
|000039c0| 7a 65 64 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |zed spre|adsheet |
|000039d0| 66 6f 72 20 6c 61 74 65 | 72 20 75 73 65 20 6f 72 |for late|r use or|
|000039e0| 20 66 6f 72 20 70 72 69 | 6e 74 69 6e 67 2e 00 42 | for pri|nting..B|
|000039f0| 54 68 69 73 20 69 73 20 | 61 6c 6c 20 71 75 69 74 |This is |all quit|
|00003a00| 65 20 73 69 6d 70 6c 65 | 2e 20 20 20 59 6f 75 20 |e simple|.   You |
|00003a10| 63 61 6e 20 66 69 6e 64 | 20 6f 75 74 20 69 6e 20 |can find| out in |
|00003a20| 6d 6f 72 65 20 64 65 74 | 61 69 6c 20 68 6f 77 20 |more det|ail how |
|00003a30| 74 6f 41 70 65 72 66 6f | 72 6d 20 65 61 63 68 20 |toAperfo|rm each |
|00003a40| 74 61 73 6b 20 62 79 20 | 72 65 66 65 72 72 69 6e |task by |referrin|
|00003a50| 67 20 74 6f 20 74 68 65 | 20 42 41 53 49 43 20 54 |g to the| BASIC T|
|00003a60| 4f 50 49 43 53 20 73 65 | 63 74 69 6f 6e 20 6f 6e |OPICS se|ction on|
|00003a70| 20 74 68 65 10 48 45 4c | 50 20 6d 65 6e 75 2e 20 | the.HEL|P menu. |
|00003a80| 20 20 20 20 20 00 3f 4e | 4f 57 20 2d 2d 20 52 65 |     .?N|OW -- Re|
|00003a90| 61 64 20 6f 6e 20 74 6f | 20 66 61 6d 69 6c 69 7a |ad on to| familiz|
|00003aa0| 65 20 79 6f 75 72 73 65 | 6c 66 20 77 69 74 68 20 |e yourse|lf with |
|00003ab0| 61 20 66 65 77 20 6e 65 | 77 20 64 65 66 69 6e 69 |a few ne|w defini|
|00003ac0| 74 69 6f 6e 73 3a 35 20 | 20 20 20 20 20 20 20 20 |tions:5 |        |
|00003ad0| 20 20 20 20 20 41 44 4a | 55 53 54 41 42 4c 45 53 |     ADJ|USTABLES|
|00003ae0| 2c 20 43 4f 4e 53 54 52 | 41 49 4e 54 53 2c 20 4f |, CONSTR|AINTS, O|
|00003af0| 42 4a 45 43 54 49 56 45 | 20 61 6e 64 1c 20 20 20 |BJECTIVE| and.   |
|00003b00| 20 20 20 20 20 20 20 20 | 20 20 20 4f 50 54 49 4d |        |   OPTIM|
|00003b10| 49 5a 41 54 49 4f 4e 2e | 20 00 00 0d b5 00 5c 3b |IZATION.| .....\;|
|00003b20| 41 44 4a 55 53 54 41 42 | 4c 45 20 63 65 6c 6c 73 |ADJUSTAB|LE cells|
|00003b30| 20 2d 2d 20 54 68 65 20 | 41 44 4a 55 53 54 41 42 | -- The |ADJUSTAB|
|00003b40| 4c 45 20 63 65 6c 6c 73 | 20 61 72 65 20 74 68 65 |LE cells| are the|
|00003b50| 20 63 65 6c 6c 73 20 74 | 68 61 74 42 63 6f 6e 74 | cells t|hatBcont|
|00003b60| 61 69 6e 20 74 68 65 20 | 76 61 72 69 61 62 6c 65 |ain the |variable|
|00003b70| 73 20 6f 66 20 74 68 65 | 20 6d 6f 64 65 6c 2e 20 |s of the| model. |
|00003b80| 20 54 68 65 73 65 20 61 | 72 65 20 74 68 65 20 63 | These a|re the c|
|00003b90| 65 6c 6c 73 20 79 6f 75 | 20 77 6f 75 6c 64 3f 6d |ells you| would?m|
|00003ba0| 61 6e 69 70 75 6c 61 74 | 65 20 69 66 20 79 6f 75 |anipulat|e if you|
|00003bb0| 20 77 65 72 65 20 61 74 | 74 65 6d 70 74 69 6e 67 | were at|tempting|
|00003bc0| 20 74 6f 20 72 65 61 63 | 68 20 74 68 65 20 6f 70 | to reac|h the op|
|00003bd0| 74 69 6d 61 6c 20 73 6f | 6c 75 74 69 6f 6e 43 74 |timal so|lutionCt|
|00003be0| 68 72 6f 75 67 68 20 22 | 57 68 61 74 20 69 66 2e |hrough "|What if.|
|00003bf0| 2e 2e 22 2e 20 20 42 65 | 73 74 20 41 6e 73 77 65 |..".  Be|st Answe|
|00003c00| 72 aa 20 63 61 6c 63 75 | 6c 61 74 65 73 20 74 68 |r. calcu|lates th|
|00003c10| 65 73 65 20 76 61 72 69 | 61 62 6c 65 73 20 28 74 |ese vari|ables (t|
|00003c20| 68 65 3e 76 61 6c 75 65 | 73 20 6f 66 20 74 68 65 |he>value|s of the|
|00003c30| 20 41 44 4a 55 53 54 41 | 42 4c 45 53 29 20 77 68 | ADJUSTA|BLES) wh|
|00003c40| 65 6e 20 79 6f 75 20 4f | 50 54 49 4d 49 5a 45 20 |en you O|PTIMIZE |
|00003c50| 79 6f 75 72 20 73 70 72 | 65 61 64 73 68 65 65 74 |your spr|eadsheet|
|00003c60| 2e 00 3d 59 6f 75 20 63 | 61 6e 20 64 65 66 69 6e |..=You c|an defin|
|00003c70| 65 20 75 70 20 74 6f 20 | 32 35 30 20 41 44 4a 55 |e up to |250 ADJU|
|00003c80| 53 54 41 42 4c 45 20 63 | 65 6c 6c 73 20 28 35 20 |STABLE c|ells (5 |
|00003c90| 41 44 4a 55 53 54 41 42 | 4c 45 20 63 65 6c 6c 73 |ADJUSTAB|LE cells|
|00003ca0| 40 69 6e 20 74 68 65 20 | 64 65 6d 6f 20 76 65 72 |@in the |demo ver|
|00003cb0| 73 69 6f 6e 29 2e 20 20 | 41 6c 6c 20 41 44 4a 55 |sion).  |All ADJU|
|00003cc0| 53 54 41 42 4c 45 20 63 | 65 6c 6c 73 20 6d 75 73 |STABLE c|ells mus|
|00003cd0| 74 20 63 6f 6e 74 61 69 | 6e 20 6e 75 6d 65 72 69 |t contai|n numeri|
|00003ce0| 63 2e 76 61 6c 75 65 73 | 3b 20 74 68 65 79 20 6d |c.values|; they m|
|00003cf0| 61 79 20 6e 6f 74 20 63 | 6f 6e 74 61 69 6e 20 66 |ay not c|ontain f|
|00003d00| 6f 72 6d 75 6c 61 73 20 | 6f 72 20 74 65 78 74 2e |ormulas |or text.|
|00003d10| 00 2e 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |..______|________|
|00003d20| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003d30| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003d40| 1b 54 6f 20 64 65 66 69 | 6e 65 20 41 44 4a 55 53 |.To defi|ne ADJUS|
|00003d50| 54 41 42 4c 45 20 63 65 | 6c 6c 73 3a 00 42 20 20 |TABLE ce|lls:.B  |
|00003d60| 20 31 29 20 20 53 65 6c | 65 63 74 20 74 68 65 20 | 1)  Sel|ect the |
|00003d70| 61 70 70 72 6f 70 72 69 | 61 74 65 20 63 65 6c 6c |appropri|ate cell|
|00003d80| 73 20 28 6a 75 73 74 20 | 6c 69 6b 65 20 79 6f 75 |s (just |like you|
|00003d90| 20 73 65 6c 65 63 74 20 | 63 65 6c 6c 73 20 69 6e | select |cells in|
|00003da0| 11 20 20 20 20 20 20 20 | 20 20 20 45 78 63 65 6c |.       |   Excel|
|00003db0| 29 2e 00 36 20 20 20 32 | 29 20 20 43 68 6f 6f 73 |)..6   2|)  Choos|
|00003dc0| 65 20 22 44 65 66 69 6e | 65 20 41 64 6a 75 73 74 |e "Defin|e Adjust|
|00003dd0| 61 62 6c 65 73 22 20 66 | 72 6f 6d 20 74 68 65 20 |ables" f|rom the |
|00003de0| 43 65 6c 6c 20 6d 65 6e | 75 2e 2e 5f 5f 5f 5f 5f |Cell men|u.._____|
|00003df0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003e00| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00003e10| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 00 00 3e 43 4f 4e 53 |________|_..>CONS|
|00003e20| 54 52 41 49 4e 54 20 63 | 65 6c 6c 73 20 2d 2d 20 |TRAINT c|ells -- |
|00003e30| 54 68 65 73 65 20 61 72 | 65 20 74 68 65 20 63 65 |These ar|e the ce|
|00003e40| 6c 6c 73 20 74 68 61 74 | 20 63 6f 6e 74 61 69 6e |lls that| contain|
|00003e50| 20 61 20 66 6f 72 6d 75 | 6c 61 3f 72 65 70 72 65 | a formu|la?repre|
|00003e60| 73 65 6e 74 69 6e 67 20 | 73 6f 6d 65 20 6b 69 6e |senting |some kin|
|00003e70| 64 20 6f 66 20 72 65 73 | 74 72 69 63 74 69 6e 67 |d of res|tricting|
|00003e80| 20 63 6f 6e 64 69 74 69 | 6f 6e 2e 20 20 54 68 69 | conditi|on.  Thi|
|00003e90| 73 20 6d 69 67 68 74 20 | 62 65 3d 69 6e 76 65 6e |s might |be=inven|
|00003ea0| 74 6f 72 79 20 28 79 6f | 75 20 63 61 6e 6e 6f 74 |tory (yo|u cannot|
|00003eb0| 20 75 73 65 20 6d 6f 72 | 65 20 69 6e 76 65 6e 74 | use mor|e invent|
|00003ec0| 6f 72 79 20 74 68 61 6e | 20 79 6f 75 20 68 61 76 |ory than| you hav|
|00003ed0| 65 29 2c 20 74 69 6d 65 | 3f 28 79 6f 75 20 63 61 |e), time|?(you ca|
|00003ee0| 6e 6e 6f 74 20 72 75 6e | 20 79 6f 75 72 20 70 72 |nnot run| your pr|
|00003ef0| 6f 64 75 63 74 69 6f 6e | 20 6d 6f 72 65 20 74 68 |oduction| more th|
|00003f00| 61 6e 20 32 34 20 68 6f | 75 72 73 20 70 65 72 20 |an 24 ho|urs per |
|00003f10| 64 61 79 29 2c 20 6f 72 | 3d 6d 6f 6e 65 79 20 28 |day), or|=money (|
|00003f20| 79 6f 75 20 63 61 6e 6e | 6f 74 20 75 73 65 20 6d |you cann|ot use m|
|00003f30| 6f 72 65 20 6d 6f 6e 65 | 79 20 74 68 61 6e 20 79 |ore mone|y than y|
|00003f40| 6f 75 20 68 61 76 65 20 | 69 6e 20 74 68 65 20 6b |ou have |in the k|
|00003f50| 69 74 74 79 29 2e 00 3b | 42 65 73 74 20 41 6e 73 |itty)..;|Best Ans|
|00003f60| 77 65 72 aa 20 65 78 70 | 65 63 74 73 20 43 4f 4e |wer. exp|ects CON|
|00003f70| 53 54 52 41 49 4e 54 20 | 63 65 6c 6c 73 20 74 6f |STRAINT |cells to|
|00003f80| 20 62 65 20 6c 69 6e 65 | 61 72 20 66 6f 72 6d 75 | be line|ar formu|
|00003f90| 6c 61 73 3b 77 68 6f 73 | 65 20 76 61 6c 75 65 73 |las;whos|e values|
|00003fa0| 20 61 72 65 20 70 6f 73 | 69 74 69 76 65 20 77 68 | are pos|itive wh|
|00003fb0| 65 6e 20 74 68 65 20 72 | 65 73 74 72 69 63 74 69 |en the r|estricti|
|00003fc0| 6f 6e 73 20 61 72 65 20 | 6d 65 74 20 61 6e 64 2b |ons are |met and+|
|00003fd0| 6e 65 67 61 74 69 76 65 | 20 77 68 65 6e 20 74 68 |negative| when th|
|00003fe0| 65 20 72 65 73 74 72 69 | 63 74 69 6f 6e 73 20 61 |e restri|ctions a|
|00003ff0| 72 65 20 62 72 6f 6b 65 | 6e 2e 20 00 41 46 6f 72 |re broke|n. .AFor|
|00004000| 20 65 78 61 6d 70 6c 65 | 2c 20 69 66 20 79 6f 75 | example|, if you|
|00004010| 20 68 61 76 65 20 61 6e | 20 22 69 6e 76 65 6e 74 | have an| "invent|
|00004020| 6f 72 79 20 69 6e 20 73 | 74 6f 63 6b 22 20 63 65 |ory in s|tock" ce|
|00004030| 6c 6c 20 28 42 33 29 20 | 61 6e 64 20 61 6e 41 22 |ll (B3) |and anA"|
|00004040| 69 6e 76 65 6e 74 6f 72 | 79 20 75 73 65 64 22 20 |inventor|y used" |
|00004050| 63 65 6c 6c 20 28 42 34 | 29 2c 20 61 6e 64 20 79 |cell (B4|), and y|
|00004060| 6f 75 20 77 61 6e 74 20 | 74 6f 20 6d 61 6b 65 20 |ou want |to make |
|00004070| 73 75 72 65 20 74 68 61 | 74 20 69 6e 76 65 6e 2d |sure tha|t inven-|
|00004080| 44 74 6f 72 79 20 75 73 | 65 64 20 69 73 20 6c 65 |Dtory us|ed is le|
|00004090| 73 73 20 74 68 61 6e 20 | 28 6f 72 20 65 71 75 61 |ss than |(or equa|
|000040a0| 6c 20 74 6f 29 20 22 69 | 6e 76 65 6e 74 6f 72 79 |l to) "i|nventory|
|000040b0| 20 69 6e 20 73 74 6f 63 | 6b 22 2c 20 79 6f 75 20 | in stoc|k", you |
|000040c0| 77 6f 75 6c 64 36 63 72 | 65 61 74 65 20 61 20 6e |would6cr|eate a n|
|000040d0| 65 77 20 63 65 6c 6c 20 | 69 6e 20 74 68 65 20 73 |ew cell |in the s|
|000040e0| 70 72 65 61 64 73 68 65 | 65 74 20 77 69 74 68 20 |preadshe|et with |
|000040f0| 74 68 65 20 66 6f 72 6d | 75 6c 61 3a 00 0b 20 20 |the form|ula:..  |
|00004100| 20 20 20 3d 42 33 2d 42 | 34 05 20 20 20 20 20 3f |   =B3-B|4.     ?|
|00004110| 54 68 69 73 20 69 73 20 | 74 68 65 20 63 65 6c 6c |This is |the cell|
|00004120| 20 74 68 61 74 20 79 6f | 75 20 77 69 6c 6c 20 64 | that yo|u will d|
|00004130| 65 66 69 6e 65 20 61 73 | 20 61 20 43 4f 4e 53 54 |efine as| a CONST|
|00004140| 52 41 49 4e 54 20 63 65 | 6c 6c 3b 20 20 69 74 15 |RAINT ce|ll;  it.|
|00004150| 63 61 6e 6e 6f 74 20 67 | 6f 20 62 65 6c 6f 77 20 |cannot g|o below |
|00004160| 7a 65 72 6f 2e 00 3b 57 | 68 65 6e 20 79 6f 75 20 |zero..;W|hen you |
|00004170| 4f 50 54 49 4d 49 5a 45 | 2c 20 42 65 73 74 20 41 |OPTIMIZE|, Best A|
|00004180| 6e 73 77 65 72 aa 20 77 | 69 6c 6c 20 6e 6f 74 20 |nswer. w|ill not |
|00004190| 76 69 6f 6c 61 74 65 20 | 61 6e 79 20 6f 66 20 74 |violate |any of t|
|000041a0| 68 65 15 64 65 66 69 6e | 65 64 20 72 65 73 74 72 |he.defin|ed restr|
|000041b0| 69 63 74 69 6f 6e 73 2e | 00 3e 4e 6f 74 65 3a 20 |ictions.|.>Note: |
|000041c0| 20 59 6f 75 20 73 65 74 | 20 75 70 20 43 4f 4e 53 | You set| up CONS|
|000041d0| 54 52 41 49 4e 54 20 63 | 65 6c 6c 73 20 66 72 6f |TRAINT c|ells fro|
|000041e0| 6d 20 77 69 74 68 69 6e | 20 45 78 63 65 6c 2e 20 |m within| Excel. |
|000041f0| 20 59 6f 75 20 63 61 6e | 3f 20 20 20 20 20 20 20 | You can|?       |
|00004200| 20 20 20 20 72 65 61 64 | 20 6d 6f 72 65 20 61 62 |    read| more ab|
|00004210| 6f 75 74 20 68 6f 77 20 | 74 6f 20 64 6f 20 74 68 |out how |to do th|
|00004220| 69 73 20 62 79 20 72 65 | 66 65 72 72 69 6e 67 20 |is by re|ferring |
|00004230| 74 6f 20 22 4d 6f 72 65 | 34 20 20 20 20 20 20 20 |to "More|4       |
|00004240| 20 20 20 20 41 62 6f 75 | 74 20 43 6f 6e 73 74 72 |    Abou|t Constr|
|00004250| 61 69 6e 74 20 43 65 6c | 6c 73 22 20 6f 6e 20 74 |aint Cel|ls" on t|
|00004260| 68 65 20 48 45 4c 50 20 | 6d 65 6e 75 2e 00 2e 5f |he HELP |menu..._|
|00004270| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004280| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004290| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 1b 54 6f |________|_____.To|
|000042a0| 20 64 65 66 69 6e 65 20 | 43 4f 4e 53 54 52 41 49 | define |CONSTRAI|
|000042b0| 4e 54 20 63 65 6c 6c 73 | 3a 00 3f 20 20 20 31 29 |NT cells|:.?   1)|
|000042c0| 20 20 53 65 6c 65 63 74 | 20 74 68 65 20 63 65 6c |  Select| the cel|
|000042d0| 6c 73 20 79 6f 75 20 77 | 61 6e 74 20 74 6f 20 64 |ls you w|ant to d|
|000042e0| 65 66 69 6e 65 20 61 73 | 20 43 4f 4e 53 54 52 41 |efine as| CONSTRA|
|000042f0| 49 4e 54 20 63 65 6c 6c | 73 2e 41 20 20 20 20 20 |INT cell|s.A     |
|00004300| 20 20 20 20 20 59 6f 75 | 20 6d 61 79 20 64 65 66 |     You| may def|
|00004310| 69 6e 65 20 75 70 20 74 | 6f 20 32 35 30 20 43 4f |ine up t|o 250 CO|
|00004320| 4e 53 54 52 41 49 4e 54 | 20 63 65 6c 6c 73 20 28 |NSTRAINT| cells (|
|00004330| 38 20 43 4f 4e 53 54 52 | 41 49 4e 54 25 20 20 20 |8 CONSTR|AINT%   |
|00004340| 20 20 20 20 20 20 20 63 | 65 6c 6c 73 20 69 6e 20 |       c|ells in |
|00004350| 74 68 65 20 64 65 6d 6f | 20 76 65 72 73 69 6f 6e |the demo| version|
|00004360| 29 2e 06 20 20 20 20 20 | 20 3b 20 20 20 32 29 20 |)..     | ;   2) |
|00004370| 20 43 68 6f 6f 73 65 20 | 22 44 65 66 69 6e 65 20 | Choose |"Define |
|00004380| 43 6f 6e 73 74 72 61 69 | 6e 74 73 22 20 66 72 6f |Constrai|nts" fro|
|00004390| 6d 20 74 68 65 20 43 65 | 6c 6c 20 6d 65 6e 75 2e |m the Ce|ll menu.|
|000043a0| 20 20 20 20 20 00 3e 52 | 45 4d 45 4d 42 45 52 3a |     .>R|EMEMBER:|
|000043b0| 20 20 20 41 6c 6c 20 43 | 4f 4e 53 54 52 41 49 4e |   All C|ONSTRAIN|
|000043c0| 54 20 63 65 6c 6c 73 20 | 6d 75 73 74 20 63 6f 6e |T cells |must con|
|000043d0| 74 61 69 6e 20 6c 69 6e | 65 61 72 20 66 6f 72 6d |tain lin|ear form|
|000043e0| 75 6c 61 73 20 3a 20 20 | 20 20 20 20 20 20 20 20 |ulas :  |        |
|000043f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 28 73 65 |        |     (se|
|00004400| 65 20 22 4c 69 6e 65 61 | 72 69 74 79 22 20 6f 6e |e "Linea|rity" on|
|00004410| 20 74 68 65 20 48 45 4c | 50 20 6d 65 6e 75 29 2e | the HEL|P menu).|
|00004420| 2e 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |._______|________|
|00004430| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004440| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 00 |________|_______.|
|00004450| 00 3f 4f 42 4a 45 43 54 | 49 56 45 20 63 65 6c 6c |.?OBJECT|IVE cell|
|00004460| 20 2d 2d 20 54 68 65 20 | 4f 42 4a 45 43 54 49 56 | -- The |OBJECTIV|
|00004470| 45 20 63 65 6c 6c 20 69 | 73 20 74 68 65 20 63 65 |E cell i|s the ce|
|00004480| 6c 6c 20 74 68 61 74 20 | 63 6f 6e 74 61 69 6e 73 |ll that |contains|
|00004490| 20 41 74 68 65 20 76 61 | 6c 75 65 20 74 68 61 74 | Athe va|lue that|
|000044a0| 20 79 6f 75 20 77 6f 75 | 6c 64 20 6c 69 6b 65 20 | you wou|ld like |
|000044b0| 74 6f 20 4f 50 54 49 4d | 49 5a 45 20 28 6d 61 78 |to OPTIM|IZE (max|
|000044c0| 69 6d 69 7a 65 20 6f 72 | 20 6d 69 6e 69 6d 69 7a |imize or| minimiz|
|000044d0| 65 29 2e 3f 54 79 70 69 | 63 61 6c 20 65 78 61 6d |e).?Typi|cal exam|
|000044e0| 70 6c 65 73 20 6f 66 20 | 4f 42 4a 45 43 54 49 56 |ples of |OBJECTIV|
|000044f0| 45 20 63 65 6c 6c 73 20 | 61 72 65 20 70 72 6f 66 |E cells |are prof|
|00004500| 69 74 20 63 65 6c 6c 73 | 20 28 66 6f 72 20 6d 61 |it cells| (for ma|
|00004510| 78 69 2d 3e 6d 69 7a 61 | 74 69 6f 6e 29 20 6f 72 |xi->miza|tion) or|
|00004520| 20 63 6f 73 74 20 63 65 | 6c 6c 73 20 28 66 6f 72 | cost ce|lls (for|
|00004530| 20 6d 69 6e 69 6d 69 7a | 61 74 69 6f 6e 29 2e 20 | minimiz|ation). |
|00004540| 20 42 65 73 74 20 41 6e | 73 77 65 72 aa 20 77 69 | Best An|swer. wi|
|00004550| 6c 6c 3e 64 65 74 65 72 | 6d 69 6e 65 20 74 68 65 |ll>deter|mine the|
|00004560| 20 63 6f 6d 62 69 6e 61 | 74 69 6f 6e 20 6f 66 20 | combina|tion of |
|00004570| 41 44 4a 55 53 54 41 42 | 4c 45 20 63 65 6c 6c 20 |ADJUSTAB|LE cell |
|00004580| 76 61 6c 75 65 73 20 74 | 68 61 74 20 79 69 65 6c |values t|hat yiel|
|00004590| 64 44 74 68 65 20 62 65 | 73 74 20 70 6f 73 73 69 |dDthe be|st possi|
|000045a0| 62 6c 65 20 61 6e 73 77 | 65 72 20 66 6f 72 20 74 |ble answ|er for t|
|000045b0| 68 65 20 4f 42 4a 45 43 | 54 49 56 45 20 63 65 6c |he OBJEC|TIVE cel|
|000045c0| 6c 2c 20 62 75 74 20 64 | 6f 65 73 20 6e 6f 74 20 |l, but d|oes not |
|000045d0| 61 6c 6c 6f 77 20 34 74 | 68 65 20 76 61 6c 75 65 |allow 4t|he value|
|000045e0| 20 6f 66 20 61 6e 79 20 | 43 4f 4e 53 54 52 41 49 | of any |CONSTRAI|
|000045f0| 4e 54 20 63 65 6c 6c 20 | 74 6f 20 62 65 63 6f 6d |NT cell |to becom|
|00004600| 65 20 6e 65 67 61 74 69 | 76 65 2e 00 2e 5f 5f 5f |e negati|ve...___|
|00004610| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004620| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004630| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 1d 54 6f 20 64 |________|___.To d|
|00004640| 65 66 69 6e 65 20 74 68 | 65 20 4f 42 4a 45 43 54 |efine th|e OBJECT|
|00004650| 49 56 45 20 63 65 6c 6c | 3a 00 40 20 20 20 31 29 |IVE cell|:.@   1)|
|00004660| 20 20 53 65 6c 65 63 74 | 20 74 68 65 20 63 65 6c |  Select| the cel|
|00004670| 6c 20 79 6f 75 20 77 61 | 6e 74 20 74 6f 20 64 65 |l you wa|nt to de|
|00004680| 66 69 6e 65 20 61 73 20 | 74 68 65 20 4f 42 4a 45 |fine as |the OBJE|
|00004690| 43 54 49 56 45 20 63 65 | 6c 6c 2e 00 34 20 20 20 |CTIVE ce|ll..4   |
|000046a0| 32 29 20 20 43 68 6f 6f | 73 65 20 22 44 65 66 69 |2)  Choo|se "Defi|
|000046b0| 6e 65 20 4f 62 6a 65 63 | 74 69 76 65 22 20 66 72 |ne Objec|tive" fr|
|000046c0| 6f 6d 20 74 68 65 20 43 | 65 6c 6c 20 6d 65 6e 75 |om the C|ell menu|
|000046d0| 2e 00 39 52 45 4d 45 4d | 42 45 52 3a 20 20 59 6f |..9REMEM|BER:  Yo|
|000046e0| 75 72 20 4f 42 4a 45 43 | 54 49 56 45 20 63 65 6c |ur OBJEC|TIVE cel|
|000046f0| 6c 20 6d 75 73 74 20 62 | 65 20 61 20 6c 69 6e 65 |l must b|e a line|
|00004700| 61 72 20 66 6f 72 6d 75 | 6c 61 2e 20 39 20 20 20 |ar formu|la. 9   |
|00004710| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |        |        |
|00004720| 20 20 20 28 73 65 65 20 | 22 4c 69 6e 65 61 72 69 |   (see |"Lineari|
|00004730| 74 79 22 20 6f 6e 20 74 | 68 65 20 48 45 4c 50 20 |ty" on t|he HELP |
|00004740| 6d 65 6e 75 29 2e 2e 5f | 5f 5f 5f 5f 5f 5f 5f 5f |menu).._|________|
|00004750| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004760| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004770| 5f 5f 5f 5f 5f 00 00 27 | 4f 50 54 49 4d 49 5a 41 |_____..'|OPTIMIZA|
|00004780| 54 49 4f 4e 20 2d 2d 20 | 54 68 69 73 20 69 73 20 |TION -- |This is |
|00004790| 74 68 65 20 66 69 6e 61 | 6c 20 73 74 65 70 21 00 |the fina|l step!.|
|000047a0| 3b 42 65 73 74 20 41 6e | 73 77 65 72 aa 20 77 69 |;Best An|swer. wi|
|000047b0| 6c 6c 20 4f 50 54 49 4d | 49 5a 45 20 79 6f 75 72 |ll OPTIM|IZE your|
|000047c0| 20 4f 42 4a 45 43 54 49 | 56 45 2c 20 77 69 74 68 | OBJECTI|VE, with|
|000047d0| 69 6e 20 74 68 65 20 67 | 69 76 65 6e 3a 43 4f 4e |in the g|iven:CON|
|000047e0| 53 54 52 41 49 4e 54 53 | 2c 20 62 79 20 63 61 6c |STRAINTS|, by cal|
|000047f0| 63 75 6c 61 74 69 6e 67 | 20 79 6f 75 72 20 41 44 |culating| your AD|
|00004800| 4a 55 53 54 41 42 4c 45 | 53 20 74 6f 20 61 74 74 |JUSTABLE|S to att|
|00004810| 61 69 6e 20 74 68 65 0e | 22 42 65 73 74 20 41 6e |ain the.|"Best An|
|00004820| 73 77 65 72 22 2e 00 2e | 5f 5f 5f 5f 5f 5f 5f 5f |swer"...|________|
|00004830| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004840| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004850| 5f 5f 5f 5f 5f 5f 0c 54 | 6f 20 4f 50 54 49 4d 49 |______.T|o OPTIMI|
|00004860| 5a 45 3a 00 3e 20 20 20 | 43 68 6f 6f 73 65 20 22 |ZE:.>   |Choose "|
|00004870| 4d 61 78 69 6d 69 7a 65 | 22 20 6f 72 20 22 4d 69 |Maximize|" or "Mi|
|00004880| 6e 69 6d 69 7a 65 22 20 | 66 72 6f 6d 20 74 68 65 |nimize" |from the|
|00004890| 20 4f 70 74 69 6d 69 7a | 61 74 69 6f 6e 20 6d 65 | Optimiz|ation me|
|000048a0| 6e 75 2e 2e 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |nu..____|________|
|000048b0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000048c0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000048d0| 5f 5f 00 00 02 96 00 11 | 3c 59 6f 75 20 73 65 74 |__......|<You set|
|000048e0| 20 75 70 20 79 6f 75 72 | 20 73 70 72 65 61 64 73 | up your| spreads|
|000048f0| 68 65 65 74 20 69 6e 20 | 45 78 63 65 6c 20 61 6e |heet in |Excel an|
|00004900| 64 20 73 61 76 65 20 69 | 74 20 69 6e 20 74 68 65 |d save i|t in the|
|00004910| 20 53 59 4c 4b 3e 66 6f | 72 6d 61 74 2e 20 20 4c | SYLK>fo|rmat.  L|
|00004920| 6f 61 64 20 79 6f 75 72 | 20 73 70 72 65 61 64 73 |oad your| spreads|
|00004930| 68 65 65 74 20 69 6e 74 | 6f 20 42 65 73 74 20 41 |heet int|o Best A|
|00004940| 6e 73 77 65 72 aa 2e 20 | 20 44 65 66 69 6e 65 20 |nswer.. | Define |
|00004950| 74 68 65 20 37 74 68 72 | 65 65 20 74 79 70 65 73 |the 7thr|ee types|
|00004960| 20 6f 66 20 63 65 6c 6c | 73 3a 20 20 41 44 4a 55 | of cell|s:  ADJU|
|00004970| 53 54 41 42 4c 45 53 2c | 20 43 4f 4e 53 54 52 41 |STABLES,| CONSTRA|
|00004980| 49 4e 54 53 20 61 6e 64 | 20 74 68 65 39 4f 42 4a |INTS and| the9OBJ|
|00004990| 45 43 54 49 56 45 20 63 | 65 6c 6c 2e 20 20 53 65 |ECTIVE c|ell.  Se|
|000049a0| 6c 65 63 74 20 22 4d 61 | 78 69 6d 69 7a 65 22 20 |lect "Ma|ximize" |
|000049b0| 6f 72 20 22 4d 69 6e 69 | 6d 69 7a 65 22 20 66 72 |or "Mini|mize" fr|
|000049c0| 6f 6d 20 74 68 65 12 4f | 70 74 69 6d 69 7a 61 74 |om the.O|ptimizat|
|000049d0| 69 6f 6e 20 6d 65 6e 75 | 2e 00 3f 54 68 65 6e 2c |ion menu|..?Then,|
|000049e0| 20 42 65 73 74 20 41 6e | 73 77 65 72 aa 20 63 61 | Best An|swer. ca|
|000049f0| 6c 63 75 6c 61 74 65 73 | 20 74 68 65 20 62 65 73 |lculates| the bes|
|00004a00| 74 20 70 6f 73 73 69 62 | 6c 65 20 61 6e 73 77 65 |t possib|le answe|
|00004a10| 72 20 66 6f 72 20 79 6f | 75 72 15 70 61 72 74 69 |r for yo|ur.parti|
|00004a20| 63 75 6c 61 72 20 73 69 | 74 75 61 74 69 6f 6e 2e |cular si|tuation.|
|00004a30| 2e 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |._______|________|
|00004a40| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004a50| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 00 |________|_______.|
|00004a60| 34 59 6f 75 20 68 61 76 | 65 20 66 69 6e 69 73 68 |4You hav|e finish|
|00004a70| 65 64 20 72 65 61 64 69 | 6e 67 20 74 68 65 20 49 |ed readi|ng the I|
|00004a80| 4e 54 52 4f 44 55 43 54 | 49 4f 4e 20 73 65 63 74 |NTRODUCT|ION sect|
|00004a90| 69 6f 6e 2e 20 00 32 54 | 6f 20 66 75 72 74 68 65 |ion. .2T|o furthe|
|00004aa0| 72 20 66 61 6d 69 6c 69 | 61 72 69 7a 65 20 79 6f |r famili|arize yo|
|00004ab0| 75 72 73 65 6c 66 20 77 | 69 74 68 20 42 65 73 74 |urself w|ith Best|
|00004ac0| 20 41 6e 73 77 65 72 aa | 3a 34 20 20 20 31 29 20 | Answer.|:4   1) |
|00004ad0| 20 52 65 61 64 20 74 68 | 72 6f 75 67 68 20 22 42 | Read th|rough "B|
|00004ae0| 61 73 69 63 20 54 6f 70 | 69 63 73 22 20 6f 6e 20 |asic Top|ics" on |
|00004af0| 74 68 65 20 48 45 4c 50 | 20 6d 65 6e 75 2e 2f 20 |the HELP| menu./ |
|00004b00| 20 20 32 29 20 20 57 6f | 72 6b 20 61 20 66 65 77 |  2)  Wo|rk a few|
|00004b10| 20 6f 66 20 74 68 65 20 | 65 78 61 6d 70 6c 65 73 | of the |examples|
|00004b20| 20 66 6f 72 20 70 72 61 | 63 74 69 63 65 2e 00 3c | for pra|ctice..<|
|00004b30| 43 6c 69 63 6b 20 22 4e | 65 78 74 22 20 6f 72 20 |Click "N|ext" or |
|00004b40| 73 65 6c 65 63 74 20 74 | 68 65 20 64 65 73 69 72 |select t|he desir|
|00004b50| 65 64 20 74 6f 70 69 63 | 20 66 72 6f 6d 20 74 68 |ed topic| from th|
|00004b60| 65 20 48 45 4c 50 20 6d | 65 6e 75 2e 00 00 00 5c |e HELP m|enu....\|
|00004b70| 00 02 39 43 6c 69 63 6b | 20 22 4e 65 78 74 22 20 |..9Click| "Next" |
|00004b80| 74 6f 20 70 72 6f 63 65 | 65 64 2c 20 6f 72 20 73 |to proce|ed, or s|
|00004b90| 65 6c 65 63 74 20 22 54 | 6f 70 69 63 73 22 20 74 |elect "T|opics" t|
|00004ba0| 6f 20 73 65 65 20 61 20 | 6c 69 73 74 1f 6f 66 20 |o see a |list.of |
|00004bb0| 74 68 65 20 74 6f 70 69 | 63 73 20 69 6e 20 74 68 |the topi|cs in th|
|00004bc0| 69 73 20 73 65 63 74 69 | 6f 6e 2e 20 00 00 03 da |is secti|on. ....|
|00004bd0| 00 18 3c 49 6e 20 6f 72 | 64 65 72 20 74 6f 20 75 |..<In or|der to u|
|00004be0| 73 65 20 42 65 73 74 20 | 41 6e 73 77 65 72 aa 2c |se Best |Answer.,|
|00004bf0| 20 79 6f 75 20 6d 75 73 | 74 20 66 69 72 73 74 20 | you mus|t first |
|00004c00| 6c 6f 61 64 20 79 6f 75 | 72 20 45 78 63 65 6c 40 |load you|r Excel@|
|00004c10| 73 70 72 65 61 64 73 68 | 65 65 74 20 69 6e 74 6f |spreadsh|eet into|
|00004c20| 20 74 68 65 20 70 72 6f | 67 72 61 6d 2e 20 20 42 | the pro|gram.  B|
|00004c30| 65 73 74 20 41 6e 73 77 | 65 72 aa 20 6f 6e 6c 79 |est Answ|er. only|
|00004c40| 20 72 65 61 64 73 20 61 | 20 73 70 72 65 61 64 2d | reads a| spread-|
|00004c50| 42 73 68 65 65 74 20 74 | 68 61 74 20 68 61 73 20 |Bsheet t|hat has |
|00004c60| 62 65 65 6e 20 73 74 6f | 72 65 64 20 69 6e 20 53 |been sto|red in S|
|00004c70| 59 4c 4b 20 28 66 6f 72 | 20 22 73 79 6d 62 6f 6c |YLK (for| "symbol|
|00004c80| 69 63 20 6c 69 6e 6b 22 | 29 20 66 6f 72 6d 61 74 |ic link"|) format|
|00004c90| 2e 20 20 00 31 49 6e 20 | 6f 72 64 65 72 20 74 6f |.  .1In |order to|
|00004ca0| 20 73 61 76 65 20 79 6f | 75 72 20 73 70 72 65 61 | save yo|ur sprea|
|00004cb0| 64 73 68 65 65 74 20 69 | 6e 20 53 59 4c 4b 20 66 |dsheet i|n SYLK f|
|00004cc0| 6f 72 6d 61 74 3a 00 43 | 20 20 31 29 20 20 53 61 |ormat:.C|  1)  Sa|
|00004cd0| 76 65 20 74 68 65 20 73 | 70 72 65 61 64 73 68 65 |ve the s|preadshe|
|00004ce0| 65 74 20 66 72 6f 6d 20 | 77 69 74 68 69 6e 20 45 |et from |within E|
|00004cf0| 78 63 65 6c 20 75 73 69 | 6e 67 20 74 68 65 20 22 |xcel usi|ng the "|
|00004d00| 53 61 76 65 20 41 73 2e | 2e 2e 22 2b 20 20 20 20 |Save As.|.."+    |
|00004d10| 20 20 20 20 20 63 6f 6d | 6d 61 6e 64 20 66 72 6f |     com|mand fro|
|00004d20| 6d 20 74 68 65 20 45 78 | 63 65 6c 20 66 69 6c 65 |m the Ex|cel file|
|00004d30| 20 6d 65 6e 75 2c 20 00 | 42 20 20 32 29 20 20 57 | menu, .|B  2)  W|
|00004d40| 68 65 6e 20 74 68 65 20 | 64 69 61 6c 6f 67 20 62 |hen the |dialog b|
|00004d50| 6f 78 20 61 70 70 65 61 | 72 73 2c 20 73 65 6c 65 |ox appea|rs, sele|
|00004d60| 63 74 20 74 68 65 20 53 | 59 4c 4b 20 72 61 64 69 |ct the S|YLK radi|
|00004d70| 6f 20 62 75 74 74 6f 6e | 20 61 74 45 20 20 20 20 |o button| atE    |
|00004d80| 20 20 20 20 20 74 68 65 | 20 62 6f 74 74 6f 6d 2e |     the| bottom.|
|00004d90| 20 43 6c 69 63 6b 20 74 | 68 65 20 22 53 61 76 65 | Click t|he "Save|
|00004da0| 22 20 62 75 74 74 6f 6e | 20 61 6e 64 20 45 78 63 |" button| and Exc|
|00004db0| 65 6c 20 77 69 6c 6c 20 | 61 75 74 6f 6d 61 74 69 |el will |automati|
|00004dc0| 2d 45 20 20 20 20 20 20 | 20 20 20 63 61 6c 6c 79 |-E      |   cally|
|00004dd0| 20 73 61 76 65 20 79 6f | 75 72 20 66 69 6c 65 20 | save yo|ur file |
|00004de0| 69 6e 20 53 59 4c 4b 20 | 66 6f 72 6d 61 74 2c 20 |in SYLK |format, |
|00004df0| 20 61 6c 6c 6f 77 69 6e | 67 20 69 74 20 74 6f 20 | allowin|g it to |
|00004e00| 62 65 20 72 65 61 64 19 | 20 20 20 20 20 20 20 20 |be read.|        |
|00004e10| 20 62 79 20 42 65 73 74 | 20 41 6e 73 77 65 72 aa | by Best| Answer.|
|00004e20| 2e 06 20 20 20 20 20 20 | 2e 5f 5f 5f 5f 5f 5f 5f |..      |._______|
|00004e30| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004e40| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004e50| 5f 5f 5f 5f 5f 5f 5f 2a | 54 6f 20 6c 6f 61 64 20 |_______*|To load |
|00004e60| 74 68 65 20 73 70 72 65 | 61 64 73 68 65 65 74 20 |the spre|adsheet |
|00004e70| 69 6e 74 6f 20 42 65 73 | 74 20 41 6e 73 77 65 72 |into Bes|t Answer|
|00004e80| aa 3a 00 1d 20 20 20 31 | 29 20 20 53 74 61 72 74 |.:..   1|)  Start|
|00004e90| 20 75 70 20 42 65 73 74 | 20 41 6e 73 77 65 72 aa | up Best| Answer.|
|00004ea0| 2e 2a 20 20 20 32 29 20 | 20 53 65 6c 65 63 74 20 |.*   2) | Select |
|00004eb0| 22 4f 70 65 6e 22 20 66 | 72 6f 6d 20 74 68 65 20 |"Open" f|rom the |
|00004ec0| 46 69 6c 65 20 4d 65 6e | 75 2e 20 20 36 20 20 20 |File Men|u.  6   |
|00004ed0| 33 29 20 20 43 68 6f 6f | 73 65 20 74 68 65 20 64 |3)  Choo|se the d|
|00004ee0| 65 73 69 72 65 64 20 66 | 69 6c 65 20 66 72 6f 6d |esired f|ile from|
|00004ef0| 20 74 68 65 20 73 65 6c | 65 63 74 69 6f 6e 20 62 | the sel|ection b|
|00004f00| 6f 78 2e 2e 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |ox..____|________|
|00004f10| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004f20| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00004f30| 5f 5f 00 39 4e 6f 74 65 | 3a 20 20 42 65 73 74 20 |__.9Note|:  Best |
|00004f40| 41 6e 73 77 65 72 aa 20 | 69 73 20 63 6f 6d 70 61 |Answer. |is compa|
|00004f50| 74 69 62 6c 65 20 77 69 | 74 68 20 53 59 4c 4b 20 |tible wi|th SYLK |
|00004f60| 66 6f 72 6d 61 74 20 66 | 69 6c 65 73 20 3c 20 20 |format f|iles <  |
|00004f70| 20 20 20 20 20 20 20 20 | 20 63 72 65 61 74 65 64 |        | created|
|00004f80| 20 62 79 20 4d 69 63 72 | 6f 73 6f 66 74 a8 20 45 | by Micr|osoft. E|
|00004f90| 78 63 65 6c 2c 20 4d 75 | 6c 74 69 70 6c 61 6e 20 |xcel, Mu|ltiplan |
|00004fa0| 6f 72 20 57 6f 72 6b 73 | 2e 20 00 00 01 d9 00 0c |or Works|. ......|
|00004fb0| 1b 54 6f 20 64 65 66 69 | 6e 65 20 41 44 4a 55 53 |.To defi|ne ADJUS|
|00004fc0| 54 41 42 4c 45 20 63 65 | 6c 6c 73 3a 00 42 20 20 |TABLE ce|lls:.B  |
|00004fd0| 20 31 29 20 20 53 65 6c | 65 63 74 20 74 68 65 20 | 1)  Sel|ect the |
|00004fe0| 61 70 70 72 6f 70 72 69 | 61 74 65 20 63 65 6c 6c |appropri|ate cell|
|00004ff0| 73 20 28 6a 75 73 74 20 | 6c 69 6b 65 20 79 6f 75 |s (just |like you|
|00005000| 20 73 65 6c 65 63 74 20 | 63 65 6c 6c 73 20 69 6e | select |cells in|
|00005010| 11 20 20 20 20 20 20 20 | 20 20 20 45 78 63 65 6c |.       |   Excel|
|00005020| 29 2e 00 36 20 20 20 32 | 29 20 20 43 68 6f 6f 73 |)..6   2|)  Choos|
|00005030| 65 20 22 44 65 66 69 6e | 65 20 41 64 6a 75 73 74 |e "Defin|e Adjust|
|00005040| 61 62 6c 65 73 22 20 66 | 72 6f 6d 20 74 68 65 20 |ables" f|rom the |
|00005050| 43 65 6c 6c 20 6d 65 6e | 75 2e 00 3d 59 6f 75 20 |Cell men|u..=You |
|00005060| 63 61 6e 20 64 65 66 69 | 6e 65 20 75 70 20 74 6f |can defi|ne up to|
|00005070| 20 32 35 30 20 41 44 4a | 55 53 54 41 42 4c 45 20 | 250 ADJ|USTABLE |
|00005080| 63 65 6c 6c 73 20 28 35 | 20 41 44 4a 55 53 54 41 |cells (5| ADJUSTA|
|00005090| 42 4c 45 20 63 65 6c 6c | 73 40 69 6e 20 74 68 65 |BLE cell|s@in the|
|000050a0| 20 64 65 6d 6f 20 76 65 | 72 73 69 6f 6e 29 2e 20 | demo ve|rsion). |
|000050b0| 20 41 6c 6c 20 41 44 4a | 55 53 54 41 42 4c 45 20 | All ADJ|USTABLE |
|000050c0| 63 65 6c 6c 73 20 6d 75 | 73 74 20 63 6f 6e 74 61 |cells mu|st conta|
|000050d0| 69 6e 20 6e 75 6d 65 72 | 69 63 40 76 61 6c 75 65 |in numer|ic@value|
|000050e0| 73 3b 20 74 68 65 79 20 | 6d 61 79 20 6e 6f 74 20 |s; they |may not |
|000050f0| 63 6f 6e 74 61 69 6e 20 | 66 6f 72 6d 75 6c 61 73 |contain |formulas|
|00005100| 20 6f 72 20 74 65 78 74 | 2e 20 20 45 61 63 68 20 | or text|.  Each |
|00005110| 20 41 44 4a 55 53 54 41 | 42 4c 45 41 63 65 6c 6c | ADJUSTA|BLEAcell|
|00005120| 20 6d 75 73 74 20 62 65 | 20 72 65 66 65 72 65 6e | must be| referen|
|00005130| 63 65 64 20 62 79 20 61 | 74 20 6c 65 61 73 74 20 |ced by a|t least |
|00005140| 6f 6e 65 20 63 6f 6e 73 | 74 72 61 69 6e 74 20 66 |one cons|traint f|
|00005150| 6f 72 6d 75 6c 61 20 6f | 72 20 74 68 65 29 6d 6f |ormula o|r the)mo|
|00005160| 64 65 6c 20 77 69 6c 6c | 20 62 65 20 63 6f 6e 73 |del will| be cons|
|00005170| 69 64 65 72 65 64 20 22 | 75 6e 63 6f 6e 73 74 72 |idered "|unconstr|
|00005180| 61 69 6e 65 64 22 2e 00 | 00 01 80 00 0a 1b 54 6f |ained"..|......To|
|00005190| 20 64 65 66 69 6e 65 20 | 43 4f 4e 53 54 52 41 49 | define |CONSTRAI|
|000051a0| 4e 54 20 63 65 6c 6c 73 | 3a 00 3e 20 20 20 31 29 |NT cells|:.>   1)|
|000051b0| 20 20 53 65 6c 65 63 74 | 20 74 68 65 20 63 65 6c |  Select| the cel|
|000051c0| 6c 73 20 79 6f 75 20 77 | 61 6e 74 20 74 6f 20 64 |ls you w|ant to d|
|000051d0| 65 66 69 6e 65 20 61 73 | 20 43 4f 4e 53 54 52 41 |efine as| CONSTRA|
|000051e0| 49 4e 54 20 63 65 6c 6c | 73 40 20 20 20 20 20 20 |INT cell|s@      |
|000051f0| 20 20 20 59 6f 75 20 6d | 61 79 20 64 65 66 69 6e |   You m|ay defin|
|00005200| 65 20 75 70 20 74 6f 20 | 32 35 30 20 43 4f 4e 53 |e up to |250 CONS|
|00005210| 54 52 41 49 4e 54 20 63 | 65 6c 6c 73 20 28 38 20 |TRAINT c|ells (8 |
|00005220| 43 4f 4e 53 54 52 41 49 | 4e 54 24 20 20 20 20 20 |CONSTRAI|NT$     |
|00005230| 20 20 20 20 63 65 6c 6c | 73 20 69 6e 20 74 68 65 |    cell|s in the|
|00005240| 20 64 65 6d 6f 20 76 65 | 72 73 69 6f 6e 29 2e 06 | demo ve|rsion)..|
|00005250| 20 20 20 20 20 20 3b 20 | 20 20 32 29 20 20 43 68 |      ; |  2)  Ch|
|00005260| 6f 6f 73 65 20 22 44 65 | 66 69 6e 65 20 43 6f 6e |oose "De|fine Con|
|00005270| 73 74 72 61 69 6e 74 73 | 22 20 66 72 6f 6d 20 74 |straints|" from t|
|00005280| 68 65 20 43 65 6c 6c 20 | 6d 65 6e 75 2e 20 20 20 |he Cell |menu.   |
|00005290| 20 20 00 3d 52 45 4d 45 | 4d 42 45 52 3a 20 20 41 |  .=REME|MBER:  A|
|000052a0| 6c 6c 20 43 4f 4e 53 54 | 52 41 49 4e 54 20 63 65 |ll CONST|RAINT ce|
|000052b0| 6c 6c 73 20 6d 75 73 74 | 20 63 6f 6e 74 61 69 6e |lls must| contain|
|000052c0| 20 6c 69 6e 65 61 72 20 | 66 6f 72 6d 75 6c 61 73 | linear |formulas|
|000052d0| 20 39 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 | 9      |        |
|000052e0| 20 20 20 20 20 20 20 20 | 28 73 65 65 20 22 4c 69 |        |(see "Li|
|000052f0| 6e 65 61 72 69 74 79 22 | 20 6f 6e 20 74 68 65 20 |nearity"| on the |
|00005300| 48 45 4c 50 20 6d 65 6e | 75 29 2e 00 00 01 12 00 |HELP men|u)......|
|00005310| 08 1d 54 6f 20 64 65 66 | 69 6e 65 20 74 68 65 20 |..To def|ine the |
|00005320| 4f 42 4a 45 43 54 49 56 | 45 20 63 65 6c 6c 3a 00 |OBJECTIV|E cell:.|
|00005330| 40 20 20 20 31 29 20 20 | 53 65 6c 65 63 74 20 74 |@   1)  |Select t|
|00005340| 68 65 20 63 65 6c 6c 20 | 79 6f 75 20 77 61 6e 74 |he cell |you want|
|00005350| 20 74 6f 20 64 65 66 69 | 6e 65 20 61 73 20 74 68 | to defi|ne as th|
|00005360| 65 20 4f 42 4a 45 43 54 | 49 56 45 20 63 65 6c 6c |e OBJECT|IVE cell|
|00005370| 2e 00 34 20 20 20 32 29 | 20 20 43 68 6f 6f 73 65 |..4   2)|  Choose|
|00005380| 20 22 44 65 66 69 6e 65 | 20 4f 62 6a 65 63 74 69 | "Define| Objecti|
|00005390| 76 65 22 20 66 72 6f 6d | 20 74 68 65 20 43 65 6c |ve" from| the Cel|
|000053a0| 6c 20 6d 65 6e 75 2e 00 | 3e 52 45 4d 45 4d 42 45 |l menu..|>REMEMBE|
|000053b0| 52 3a 20 20 59 6f 75 72 | 20 4f 42 4a 45 43 54 49 |R:  Your| OBJECTI|
|000053c0| 56 45 20 63 65 6c 6c 20 | 6d 75 73 74 20 63 6f 6e |VE cell |must con|
|000053d0| 74 61 69 6e 20 61 20 6c | 69 6e 65 61 72 20 66 6f |tain a l|inear fo|
|000053e0| 72 6d 75 6c 61 2e 20 39 | 20 20 20 20 20 20 20 20 |rmula. 9|        |
|000053f0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 28 73 |        |      (s|
|00005400| 65 65 20 22 4c 69 6e 65 | 61 72 69 74 79 22 20 6f |ee "Line|arity" o|
|00005410| 6e 20 74 68 65 20 48 45 | 4c 50 20 6d 65 6e 75 29 |n the HE|LP menu)|
|00005420| 2e 00 00 01 cb 00 0c 3a | 41 66 74 65 72 20 79 6f |.......:|After yo|
|00005430| 75 20 68 61 76 65 20 69 | 64 65 6e 74 69 66 69 65 |u have i|dentifie|
|00005440| 64 20 74 68 65 20 41 64 | 6a 75 73 74 61 62 6c 65 |d the Ad|justable|
|00005450| 2c 20 43 6f 6e 73 74 72 | 61 69 6e 74 2c 20 61 6e |, Constr|aint, an|
|00005460| 64 20 36 4f 62 6a 65 63 | 74 69 76 65 20 43 65 6c |d 6Objec|tive Cel|
|00005470| 6c 73 2c 20 79 6f 75 20 | 61 72 65 20 72 65 61 64 |ls, you |are read|
|00005480| 79 20 74 6f 20 4f 70 74 | 69 6d 69 7a 65 20 79 6f |y to Opt|imize yo|
|00005490| 75 72 20 6d 6f 64 65 6c | 2e 00 2e 5f 5f 5f 5f 5f |ur model|..._____|
|000054a0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000054b0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|000054c0| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 0c 54 6f 20 4f 50 54 |________|_.To OPT|
|000054d0| 49 4d 49 5a 45 3a 00 3b | 43 68 6f 6f 73 65 20 22 |IMIZE:.;|Choose "|
|000054e0| 4d 61 78 69 6d 69 7a 65 | 22 20 6f 72 20 22 4d 69 |Maximize|" or "Mi|
|000054f0| 6e 69 6d 69 7a 65 22 20 | 66 72 6f 6d 20 74 68 65 |nimize" |from the|
|00005500| 20 4f 50 54 49 4d 49 5a | 41 54 49 4f 4e 20 6d 65 | OPTIMIZ|ATION me|
|00005510| 6e 75 2e 2e 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |nu..____|________|
|00005520| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005530| 5f 5f 5f 5f 5f 5f 5f 5f | 5f 5f 5f 5f 5f 5f 5f 5f |________|________|
|00005540| 5f 5f 00 43 41 20 64 69 | 61 6c 6f 67 20 62 6f 78 |__.CA di|alog box|
|00005550| 20 77 69 6c 6c 20 61 70 | 70 65 61 72 2c 20 64 69 | will ap|pear, di|
|00005560| 73 70 6c 61 79 69 6e 67 | 20 74 68 65 20 62 65 73 |splaying| the bes|
|00005570| 74 20 61 6e 73 77 65 72 | 20 61 73 20 69 74 20 69 |t answer| as it i|
|00005580| 73 20 62 65 69 6e 67 41 | 63 61 6c 63 75 6c 61 74 |s beingA|calculat|
|00005590| 65 64 2e 20 20 59 6f 75 | 20 6d 61 79 20 73 74 6f |ed.  You| may sto|
|000055a0| 70 20 74 68 65 20 6f 70 | 74 69 6d 69 7a 61 74 69 |p the op|timizati|
|000055b0| 6f 6e 20 70 72 6f 63 65 | 73 73 20 61 74 20 61 6e |on proce|ss at an|
|000055c0| 79 20 74 69 6d 65 20 62 | 79 26 63 6c 69 63 6b 69 |y time b|y&clicki|
|000055d0| 6e 67 20 74 68 65 20 22 | 53 74 6f 70 22 20 62 75 |ng the "|Stop" bu|
|000055e0| 74 74 6f 6e 20 69 6e 20 | 74 68 65 20 62 6f 78 2e |tton in |the box.|
|000055f0| 00 00 04 bf 00 17 3c 42 | 65 73 74 20 41 6e 73 77 |......<B|est Answ|
|00005600| 65 72 aa 20 6d 61 79 20 | 62 65 20 72 75 6e 20 63 |er. may |be run c|
|00005610| 6f 6e 63 75 72 72 65 6e | 74 6c 79 20 77 69 74 68 |oncurren|tly with|
|00005620| 20 45 78 63 65 6c 20 75 | 73 69 6e 67 20 65 69 74 | Excel u|sing eit|
|00005630| 68 65 72 3e 53 77 69 74 | 63 68 65 72 20 6f 72 20 |her>Swit|cher or |
|00005640| 4d 75 6c 74 69 46 69 6e | 64 65 72 20 74 6f 20 69 |MultiFin|der to i|
|00005650| 6e 63 72 65 61 73 65 20 | 74 68 65 20 65 66 66 69 |ncrease |the effi|
|00005660| 63 69 65 6e 63 79 20 6f | 66 20 63 72 65 61 74 69 |ciency o|f creati|
|00005670| 6e 67 42 61 6e 64 20 6f | 70 74 69 6d 69 7a 69 6e |ngBand o|ptimizin|
|00005680| 67 20 6d 6f 64 65 6c 73 | 2e 20 20 57 68 65 6e 20 |g models|.  When |
|00005690| 72 75 6e 6e 69 6e 67 20 | 69 6e 20 6f 6e 65 20 6f |running |in one o|
|000056a0| 66 20 74 68 65 73 65 20 | 65 6e 76 69 72 6f 6e 6d |f these |environm|
|000056b0| 65 6e 74 73 2c 40 79 6f | 75 20 63 61 6e 20 68 61 |ents,@yo|u can ha|
|000056c0| 76 65 20 74 68 65 20 73 | 61 6d 65 20 66 69 6c 65 |ve the s|ame file|
|000056d0| 20 6f 70 65 6e 20 69 6e | 20 62 6f 74 68 20 70 72 | open in| both pr|
|000056e0| 6f 67 72 61 6d 73 2c 20 | 6d 61 6b 69 6e 67 20 63 |ograms, |making c|
|000056f0| 68 61 6e 67 65 73 3e 69 | 6e 20 45 78 63 65 6c 20 |hanges>i|n Excel |
|00005700| 61 6e 64 20 6f 70 74 69 | 6d 69 7a 69 6e 67 20 69 |and opti|mizing i|
|00005710| 6e 20 42 65 73 74 20 41 | 6e 73 77 65 72 aa 2e 20 |n Best A|nswer.. |
|00005720| 20 54 6f 20 61 6c 6c 6f | 77 20 6f 6e 65 20 70 72 | To allo|w one pr|
|00005730| 6f 67 72 61 6d 38 74 6f | 20 61 63 63 65 73 73 20 |ogram8to| access |
|00005740| 63 68 61 6e 67 65 73 20 | 6d 61 64 65 20 69 6e 20 |changes |made in |
|00005750| 74 68 65 20 6f 74 68 65 | 72 2c 20 66 6f 6c 6c 6f |the othe|r, follo|
|00005760| 77 20 74 68 65 73 65 20 | 73 74 65 70 73 3a 00 41 |w these |steps:.A|
|00005770| 20 20 31 29 20 20 53 61 | 76 65 20 74 68 65 20 73 |  1)  Sa|ve the s|
|00005780| 70 72 65 61 64 73 68 65 | 65 74 20 62 79 20 63 68 |preadshe|et by ch|
|00005790| 6f 6f 73 69 6e 67 20 22 | 53 61 76 65 22 20 66 72 |oosing "|Save" fr|
|000057a0| 6f 6d 20 74 68 65 20 46 | 69 6c 65 20 4d 65 6e 75 |om the F|ile Menu|
|000057b0| 2e 22 20 20 32 29 20 20 | 53 77 69 74 63 68 20 74 |."  2)  |Switch t|
|000057c0| 6f 20 74 68 65 20 6f 74 | 68 65 72 20 70 72 6f 67 |o the ot|her prog|
|000057d0| 72 61 6d 2e 42 20 20 33 | 29 20 20 43 6c 6f 73 65 |ram.B  3|)  Close|
|000057e0| 20 61 6e 64 20 74 68 65 | 6e 20 72 65 2d 6f 70 65 | and the|n re-ope|
|000057f0| 6e 20 74 68 65 20 63 68 | 61 6e 67 65 64 20 66 69 |n the ch|anged fi|
|00005800| 6c 65 20 28 49 6e 20 42 | 65 73 74 20 41 6e 73 77 |le (In B|est Answ|
|00005810| 65 72 aa 20 79 6f 75 35 | 20 20 20 20 20 20 20 20 |er. you5|        |
|00005820| 20 63 61 6e 20 75 73 65 | 20 74 68 65 20 22 52 65 | can use| the "Re|
|00005830| 76 65 72 74 22 20 63 6f | 6d 6d 61 6e 64 20 61 73 |vert" co|mmand as|
|00005840| 20 61 20 73 68 6f 72 74 | 63 75 74 29 2e 00 42 55 | a short|cut)..BU|
|00005850| 73 69 6e 67 20 4d 75 6c | 74 69 46 69 6e 64 65 72 |sing Mul|tiFinder|
|00005860| 20 72 65 71 75 69 72 65 | 73 20 61 20 6c 6f 74 20 | require|s a lot |
|00005870| 6f 66 20 6d 65 6d 6f 72 | 79 20 28 61 74 20 6c 65 |of memor|y (at le|
|00005880| 61 73 74 20 6f 6e 65 20 | 6d 65 67 61 62 79 74 65 |ast one |megabyte|
|00005890| 29 30 77 68 69 63 68 20 | 6d 61 79 20 72 75 6c 65 |)0which |may rule|
|000058a0| 20 6f 75 74 20 4d 75 6c | 74 69 46 69 6e 64 65 72 | out Mul|tiFinder|
|000058b0| 20 66 6f 72 20 6c 61 72 | 67 65 20 6d 6f 64 65 6c | for lar|ge model|
|000058c0| 73 2e 00 3e 55 73 69 6e | 67 20 53 77 69 74 63 68 |s..>Usin|g Switch|
|000058d0| 65 72 20 72 65 71 75 69 | 72 65 73 20 6c 65 73 73 |er requi|res less|
|000058e0| 20 6d 65 6d 6f 72 79 20 | 62 75 74 20 69 73 20 6e | memory |but is n|
|000058f0| 6f 74 20 61 6c 77 61 79 | 73 20 72 65 6c 69 61 62 |ot alway|s reliab|
|00005900| 6c 65 3c 77 69 74 68 20 | 74 68 65 20 6e 65 77 65 |le<with |the newe|
|00005910| 72 20 73 79 73 74 65 6d | 20 73 6f 66 74 77 61 72 |r system| softwar|
|00005920| 65 2e 20 20 28 4e 6f 74 | 65 3a 20 41 70 70 6c 65 |e.  (Not|e: Apple|
|00005930| 20 68 61 73 20 6f 66 66 | 69 63 69 61 6c 6c 79 3c | has off|icially<|
|00005940| 64 69 73 63 6f 6e 74 69 | 6e 75 65 64 20 53 77 69 |disconti|nued Swi|
|00005950| 74 63 68 65 72 20 61 6e | 64 20 64 6f 65 73 20 6e |tcher an|d does n|
|00005960| 6f 74 20 67 75 61 72 61 | 6e 74 65 65 20 69 74 20 |ot guara|ntee it |
|00005970| 74 6f 20 77 6f 72 6b 20 | 77 69 74 68 3f 61 6e 79 |to work |with?any|
|00005980| 20 63 75 72 72 65 6e 74 | 20 6f 72 20 66 75 74 75 | current| or futu|
|00005990| 72 65 20 68 61 72 64 77 | 61 72 65 2f 73 79 73 74 |re hardw|are/syst|
|000059a0| 65 6d 20 73 6f 66 74 77 | 61 72 65 20 63 6f 6e 66 |em softw|are conf|
|000059b0| 69 67 75 72 61 74 69 6f | 6e 73 2e 29 3f 42 65 20 |iguratio|ns.)?Be |
|000059c0| 73 75 72 65 20 74 6f 20 | 75 73 65 20 74 68 65 20 |sure to |use the |
|000059d0| 6c 61 74 65 73 74 20 76 | 65 72 73 69 6f 6e 20 6f |latest v|ersion o|
|000059e0| 66 20 53 77 69 74 63 68 | 65 72 2e 20 20 59 6f 75 |f Switch|er.  You|
|000059f0| 20 6d 61 79 20 75 73 65 | 20 74 68 65 3d 53 77 69 | may use| the=Swi|
|00005a00| 74 63 68 65 72 20 73 65 | 74 20 74 68 61 74 20 63 |tcher se|t that c|
|00005a10| 6f 6d 65 73 20 6f 6e 20 | 74 68 65 20 70 72 6f 67 |omes on |the prog|
|00005a20| 72 61 6d 20 64 69 73 6b | 20 6f 72 20 63 6f 6e 66 |ram disk| or conf|
|00005a30| 69 67 75 72 65 20 79 6f | 75 72 40 6f 77 6e 20 73 |igure yo|ur@own s|
|00005a40| 65 74 20 28 45 78 63 65 | 6c 20 73 68 6f 75 6c 64 |et (Exce|l should|
|00005a50| 20 62 65 20 74 68 65 20 | 66 69 72 73 74 20 70 72 | be the |first pr|
|00005a60| 6f 67 72 61 6d 20 6c 6f | 61 64 65 64 29 2e 20 20 |ogram lo|aded).  |
|00005a70| 49 66 20 79 6f 75 20 68 | 61 76 65 37 70 72 6f 62 |If you h|ave7prob|
|00005a80| 6c 65 6d 73 2c 20 74 72 | 79 20 75 73 69 6e 67 20 |lems, tr|y using |
|00005a90| 4d 75 6c 74 69 46 69 6e | 64 65 72 20 6f 72 20 72 |MultiFin|der or r|
|00005aa0| 75 6e 6e 69 6e 67 20 73 | 74 61 6e 64 2d 61 6c 6f |unning s|tand-alo|
|00005ab0| 6e 65 2e 00 00 01 62 00 | 0a 3a 42 65 73 74 20 41 |ne....b.|.:Best A|
|00005ac0| 6e 73 77 65 72 aa 20 73 | 75 70 70 6f 72 74 73 20 |nswer. s|upports |
|00005ad0| 6f 6e 6c 79 20 74 68 65 | 20 66 6f 6c 6c 6f 77 69 |only the| followi|
|00005ae0| 6e 67 20 45 78 63 65 6c | 20 66 75 6e 63 74 69 6f |ng Excel| functio|
|00005af0| 6e 73 3a 20 00 13 20 20 | 20 20 a5 20 20 61 64 64 |ns: ..  |  .  add|
|00005b00| 69 74 69 6f 6e 20 28 2b | 29 16 20 20 20 20 a5 20 |ition (+|).    . |
|00005b10| 20 73 75 62 74 72 61 63 | 74 69 6f 6e 20 28 2d 29 | subtrac|tion (-)|
|00005b20| 19 20 20 20 20 a5 20 20 | 6d 75 6c 74 69 70 6c 69 |.    .  |multipli|
|00005b30| 63 61 74 69 6f 6e 20 28 | 2a 29 1b 20 20 20 20 a5 |cation (|*).    .|
|00005b40| 20 20 64 69 76 69 73 69 | 6f 6e 20 28 2f 29 20 20 |  divisi|on (/)  |
|00005b50| 20 20 20 20 20 20 16 20 | 20 20 20 a5 20 20 73 75 |      . |   .  su|
|00005b60| 6d 6d 61 74 69 6f 6e 20 | 28 53 55 4d 29 3b 20 20 |mmation |(SUM);  |
|00005b70| 20 20 20 20 20 20 4e 6f | 74 65 3a 20 54 68 65 20 |      No|te: The |
|00005b80| 53 55 4d 20 66 75 6e 63 | 74 69 6f 6e 20 69 6e 20 |SUM func|tion in |
|00005b90| 42 65 73 74 20 41 6e 73 | 77 65 72 aa 20 68 61 6e |Best Ans|wer. han|
|00005ba0| 64 6c 65 73 20 63 65 6c | 6c 41 20 20 20 20 20 20 |dles cel|lA      |
|00005bb0| 20 20 20 20 20 20 20 20 | 20 20 20 20 72 65 66 65 |        |    refe|
|00005bc0| 72 65 6e 63 65 73 20 69 | 6e 20 72 61 6e 67 65 73 |rences i|n ranges|
|00005bd0| 3a 20 53 55 4d 28 41 31 | 3a 42 33 2c 43 35 3a 44 |: SUM(A1|:B3,C5:D|
|00005be0| 37 29 2c 20 62 75 74 20 | 6e 6f 74 2d 20 20 20 20 |7), but |not-    |
|00005bf0| 20 20 20 20 20 20 20 20 | 20 20 20 20 20 20 65 78 |        |      ex|
|00005c00| 70 72 65 73 73 69 6f 6e | 73 3a 20 53 55 4d 28 41 |pression|s: SUM(A|
|00005c10| 31 2a 33 2c 41 32 2a 34 | 29 00 00 03 07 00 12 40 |1*3,A2*4|)......@|
|00005c20| 54 68 65 72 65 20 61 72 | 65 20 73 65 76 65 72 61 |There ar|e severa|
|00005c30| 6c 20 64 69 66 66 65 72 | 65 6e 74 20 62 75 73 69 |l differ|ent busi|
|00005c40| 6e 65 73 73 20 73 69 74 | 75 61 74 69 6f 6e 73 20 |ness sit|uations |
|00005c50| 74 68 61 74 20 63 61 6e | 20 62 65 6e 65 66 69 74 |that can| benefit|
|00005c60| 41 66 72 6f 6d 20 6f 70 | 74 69 6d 69 7a 61 74 69 |Afrom op|timizati|
|00005c70| 6f 6e 2e 20 20 45 78 61 | 6d 70 6c 65 73 20 69 6e |on.  Exa|mples in|
|00005c80| 63 6c 75 64 65 3a 20 20 | 4d 61 6e 75 66 61 63 74 |clude:  |Manufact|
|00005c90| 75 72 69 6e 67 20 50 72 | 6f 64 75 63 74 20 4d 69 |uring Pr|oduct Mi|
|00005ca0| 78 2c 40 53 63 68 65 64 | 75 6c 69 6e 67 2c 20 50 |x,@Sched|uling, P|
|00005cb0| 6f 72 74 66 6f 6c 69 6f | 20 53 65 6c 65 63 74 69 |ortfolio| Selecti|
|00005cc0| 6f 6e 2c 20 4d 65 64 69 | 61 20 42 75 79 69 6e 67 |on, Medi|a Buying|
|00005cd0| 2c 20 42 6c 65 6e 64 69 | 6e 67 20 61 6e 64 20 43 |, Blendi|ng and C|
|00005ce0| 61 73 68 0e 46 6c 6f 77 | 20 41 6e 61 6c 79 73 69 |ash.Flow| Analysi|
|00005cf0| 73 2e 00 3d 4f 6e 20 74 | 68 65 20 70 72 6f 67 72 |s..=On t|he progr|
|00005d00| 61 6d 20 64 69 73 6b 20 | 79 6f 75 20 72 65 63 65 |am disk |you rece|
|00005d10| 69 76 65 64 2c 20 74 68 | 65 72 65 20 69 73 20 61 |ived, th|ere is a|
|00005d20| 20 22 53 61 6d 70 6c 65 | 73 22 20 66 6f 6c 64 65 | "Sample|s" folde|
|00005d30| 72 41 63 6f 6e 74 61 69 | 6e 69 6e 67 20 73 69 78 |rAcontai|ning six|
|00005d40| 20 64 69 66 66 65 72 65 | 6e 74 20 65 78 61 6d 70 | differe|nt examp|
|00005d50| 6c 65 20 73 70 72 65 61 | 64 73 68 65 65 74 73 2e |le sprea|dsheets.|
|00005d60| 20 20 54 68 65 20 6e 65 | 78 74 20 73 69 78 20 48 |  The ne|xt six H|
|00005d70| 45 4c 50 33 74 6f 70 69 | 63 73 20 73 65 74 20 75 |ELP3topi|cs set u|
|00005d80| 70 20 74 68 65 20 62 61 | 73 69 63 20 73 63 65 6e |p the ba|sic scen|
|00005d90| 65 72 69 6f 73 20 66 6f | 72 20 65 61 63 68 20 65 |erios fo|r each e|
|00005da0| 78 61 6d 70 6c 65 2e 00 | 40 54 68 65 20 66 69 72 |xample..|@The fir|
|00005db0| 73 74 20 65 78 61 6d 70 | 6c 65 20 69 73 20 61 20 |st examp|le is a |
|00005dc0| 76 65 72 79 20 73 69 6d | 70 6c 65 20 6d 6f 64 65 |very sim|ple mode|
|00005dd0| 6c 20 77 68 69 63 68 20 | 61 6c 6c 6f 77 73 20 79 |l which |allows y|
|00005de0| 6f 75 20 74 6f 20 67 65 | 74 41 79 6f 75 72 20 66 |ou to ge|tAyour f|
|00005df0| 65 65 74 20 77 65 74 2e | 20 20 54 68 65 20 6f 74 |eet wet.|  The ot|
|00005e00| 68 65 72 20 66 69 76 65 | 20 65 78 61 6d 70 6c 65 |her five| example|
|00005e10| 73 20 61 72 65 20 6d 6f | 72 65 20 72 65 61 6c 69 |s are mo|re reali|
|00005e20| 73 74 69 63 20 6d 6f 64 | 65 6c 73 37 6f 66 20 68 |stic mod|els7of h|
|00005e30| 6f 77 20 79 6f 75 20 6d | 69 67 68 74 20 75 73 65 |ow you m|ight use|
|00005e40| 20 42 65 73 74 20 41 6e | 73 77 65 72 aa 20 69 6e | Best An|swer. in|
|00005e50| 20 79 6f 75 72 20 6f 77 | 6e 20 62 75 73 69 6e 65 | your ow|n busine|
|00005e60| 73 73 2e 00 3c 54 68 65 | 73 65 20 65 78 61 6d 70 |ss..<The|se examp|
|00005e70| 6c 65 20 73 70 72 65 61 | 64 73 68 65 65 74 73 20 |le sprea|dsheets |
|00005e80| 77 69 6c 6c 20 73 65 72 | 76 65 20 62 6f 74 68 20 |will ser|ve both |
|00005e90| 61 73 20 61 6e 20 65 64 | 75 63 61 74 69 6f 6e 61 |as an ed|ucationa|
|00005ea0| 6c 3c 74 6f 6f 6c 20 61 | 6e 64 20 61 73 20 62 61 |l<tool a|nd as ba|
|00005eb0| 73 69 63 20 6d 6f 64 65 | 6c 73 20 28 74 65 6d 70 |sic mode|ls (temp|
|00005ec0| 6c 61 74 65 73 29 20 66 | 6f 72 20 73 65 74 74 69 |lates) f|or setti|
|00005ed0| 6e 67 20 75 70 20 79 6f | 75 72 20 6f 77 6e 0d 73 |ng up yo|ur own.s|
|00005ee0| 70 72 65 61 64 73 68 65 | 65 74 73 2e 00 36 20 20 |preadshe|ets..6  |
|00005ef0| 20 20 20 20 20 20 20 43 | 6c 69 63 6b 20 22 4e 45 |       C|lick "NE|
|00005f00| 58 54 22 20 74 6f 20 72 | 65 61 64 20 61 62 6f 75 |XT" to r|ead abou|
|00005f10| 74 20 74 68 65 20 66 69 | 72 73 74 20 65 78 61 6d |t the fi|rst exam|
|00005f20| 70 6c 65 2e 00 00 05 24 | 00 24 40 59 6f 75 20 61 |ple....$|.$@You a|
|00005f30| 72 65 20 52 61 79 2c 20 | 74 68 65 20 66 72 69 65 |re Ray, |the frie|
|00005f40| 6e 64 6c 79 20 6e 65 69 | 67 68 62 6f 72 68 6f 6f |ndly nei|ghborhoo|
|00005f50| 64 20 73 61 75 73 61 67 | 65 20 6d 61 6b 65 72 2e |d sausag|e maker.|
|00005f60| 20 20 59 6f 75 20 6d 61 | 6b 65 20 42 66 69 76 65 |  You ma|ke Bfive|
|00005f70| 20 64 69 66 66 65 72 65 | 6e 74 20 6b 69 6e 64 73 | differe|nt kinds|
|00005f80| 20 6f 66 20 73 61 75 73 | 61 67 65 20 62 79 20 63 | of saus|age by c|
|00005f90| 6f 6d 62 69 6e 69 6e 67 | 20 73 61 75 73 61 67 65 |ombining| sausage|
|00005fa0| 20 63 61 73 69 6e 67 73 | 20 77 69 74 68 20 2b 74 | casings| with +t|
|00005fb0| 68 72 65 65 20 74 79 70 | 65 73 20 6f 66 20 6d 65 |hree typ|es of me|
|00005fc0| 61 74 3a 20 76 65 61 6c | 2c 20 70 6f 72 6b 20 61 |at: veal|, pork a|
|00005fd0| 6e 64 20 62 65 65 66 2e | 20 20 00 40 45 61 63 68 |nd beef.|  .@Each|
|00005fe0| 20 6e 69 67 68 74 20 79 | 6f 75 20 67 6f 20 68 6f | night y|ou go ho|
|00005ff0| 6d 65 20 61 6e 64 20 70 | 6c 61 6e 20 74 68 65 20 |me and p|lan the |
|00006000| 70 72 6f 64 75 63 74 69 | 6f 6e 20 73 63 68 65 64 |producti|on sched|
|00006010| 75 6c 65 20 66 6f 72 20 | 74 68 65 20 0e 66 6f 6c |ule for |the .fol|
|00006020| 6c 6f 77 69 6e 67 20 64 | 61 79 2e 00 3b 53 68 6f |lowing d|ay..;Sho|
|00006030| 75 6c 64 20 79 6f 75 20 | 6d 61 6b 65 20 32 35 30 |uld you |make 250|
|00006040| 20 62 72 61 74 77 75 72 | 73 74 2c 20 35 30 30 20 | bratwur|st, 500 |
|00006050| 49 74 61 6c 69 61 6e 20 | 53 61 75 73 61 67 65 73 |Italian |Sausages|
|00006060| 20 61 6e 64 20 37 38 35 | 3f 50 6f 6c 69 73 68 20 | and 785|?Polish |
|00006070| 53 61 75 73 61 67 65 73 | 3f 20 20 4f 72 20 77 6f |Sausages|?  Or wo|
|00006080| 75 6c 64 20 69 74 20 62 | 65 20 62 65 74 74 65 72 |uld it b|e better|
|00006090| 20 74 6f 20 66 6f 72 67 | 65 74 20 74 68 65 20 62 | to forg|et the b|
|000060a0| 72 61 74 77 75 72 73 74 | 42 61 6c 74 6f 67 65 74 |ratwurst|Baltoget|
|000060b0| 68 65 72 20 61 6e 64 20 | 75 73 65 20 75 70 20 74 |her and |use up t|
|000060c0| 68 65 20 72 65 73 74 20 | 6f 66 20 74 68 65 20 70 |he rest |of the p|
|000060d0| 6f 72 6b 20 69 6e 20 6d | 61 6b 69 6e 67 20 61 20 |ork in m|aking a |
|000060e0| 65 78 74 72 61 20 6c 61 | 72 67 65 3a 62 61 74 63 |extra la|rge:batc|
|000060f0| 68 20 6f 66 20 70 65 70 | 70 65 72 6f 6e 69 2c 20 |h of pep|peroni, |
|00006100| 61 6c 6c 6f 77 69 6e 67 | 20 74 68 65 20 76 65 61 |allowing| the vea|
|00006110| 6c 20 74 6f 20 22 67 6f | 20 74 6f 20 74 68 65 20 |l to "go| to the |
|00006120| 64 6f 67 73 22 3f 00 28 | 59 4f 55 52 20 4d 49 53 |dogs"?.(|YOUR MIS|
|00006130| 53 49 4f 4e 3a 20 20 54 | 6f 20 4d 61 78 69 6d 69 |SION:  T|o Maximi|
|00006140| 7a 65 20 47 72 6f 73 73 | 20 50 72 6f 66 69 74 21 |ze Gross| Profit!|
|00006150| 00 24 54 68 69 73 20 69 | 73 20 77 68 65 72 65 20 |.$This i|s where |
|00006160| 42 65 73 74 20 41 6e 73 | 77 65 72 aa 20 63 6f 6d |Best Ans|wer. com|
|00006170| 65 73 20 69 6e 2e 00 2e | 46 69 72 73 74 2c 20 6c |es in...|First, l|
|00006180| 6f 61 64 20 74 68 65 20 | 73 70 72 65 61 64 73 68 |oad the |spreadsh|
|00006190| 65 65 74 20 69 6e 74 6f | 20 42 65 73 74 20 41 6e |eet into| Best An|
|000061a0| 73 77 65 72 aa 2e 00 3d | 54 68 65 6e 2c 20 64 65 |swer...=|Then, de|
|000061b0| 66 69 6e 65 20 79 6f 75 | 72 20 43 6f 6e 73 74 72 |fine you|r Constr|
|000061c0| 61 69 6e 74 20 63 65 6c | 6c 73 2c 20 41 64 6a 75 |aint cel|ls, Adju|
|000061d0| 73 74 61 62 6c 65 20 63 | 65 6c 6c 73 20 61 6e 64 |stable c|ells and|
|000061e0| 20 79 6f 75 72 25 4f 62 | 6a 65 63 74 69 76 65 20 | your%Ob|jective |
|000061f0| 63 65 6c 6c 20 20 28 68 | 69 6e 74 3a 20 73 65 65 |cell  (h|int: see|
|00006200| 20 43 65 6c 6c 20 6d 65 | 6e 75 29 00 43 20 20 20 | Cell me|nu).C   |
|00006210| 20 4e 4f 54 45 3a 20 20 | 45 61 63 68 20 74 79 70 | NOTE:  |Each typ|
|00006220| 65 20 6f 66 20 63 65 6c | 6c 20 74 68 61 74 20 6e |e of cel|l that n|
|00006230| 65 65 64 73 20 74 6f 20 | 62 65 20 64 65 66 69 6e |eeds to |be defin|
|00006240| 65 64 20 69 73 20 6c 61 | 62 65 6c 65 64 20 6f 6e |ed is la|beled on|
|00006250| 28 20 20 20 20 20 20 20 | 20 20 20 20 20 20 20 20 |(       |        |
|00006260| 20 74 68 65 20 65 78 61 | 6d 70 6c 65 20 73 70 72 | the exa|mple spr|
|00006270| 65 61 64 73 68 65 65 74 | 3a 00 35 20 20 20 20 20 |eadsheet|:.5     |
|00006280| 20 20 20 20 20 a5 20 20 | 43 6f 6e 73 74 72 61 69 |     .  |Constrai|
|00006290| 6e 74 73 20 61 72 65 20 | 22 69 6e 76 65 6e 74 6f |nts are |"invento|
|000062a0| 72 79 20 72 65 6d 61 69 | 6e 69 6e 67 22 2e 20 20 |ry remai|ning".  |
|000062b0| 37 20 20 20 20 20 20 20 | 20 20 20 a5 20 20 41 64 |7       |   .  Ad|
|000062c0| 6a 75 73 74 61 62 6c 65 | 73 20 61 72 65 20 74 68 |justable|s are th|
|000062d0| 65 20 22 71 75 61 6e 74 | 69 74 79 20 74 6f 20 70 |e "quant|ity to p|
|000062e0| 72 6f 64 75 63 65 22 2e | 2e 20 20 20 20 20 20 20 |roduce".|.       |
|000062f0| 20 20 20 a5 20 20 4f 62 | 6a 65 63 74 69 76 65 20 |   .  Ob|jective |
|00006300| 63 65 6c 6c 20 69 73 20 | 22 47 72 6f 73 73 20 50 |cell is |"Gross P|
|00006310| 72 6f 66 69 74 22 2e 00 | 36 46 69 6e 61 6c 6c 79 |rofit"..|6Finally|
|00006320| 2c 20 63 68 6f 6f 73 65 | 20 22 4d 61 78 69 6d 69 |, choose| "Maximi|
|00006330| 7a 65 22 20 66 72 6f 6d | 20 74 68 65 20 4f 70 74 |ze" from| the Opt|
|00006340| 69 6d 69 7a 61 74 69 6f | 6e 20 6d 65 6e 75 2e 00 |imizatio|n menu..|
|00006350| 3c 56 6f 69 6c 61 21 20 | 20 42 65 73 74 20 41 6e |<Voila! | Best An|
|00006360| 73 77 65 72 aa 20 67 6f | 65 73 20 74 6f 20 77 6f |swer. go|es to wo|
|00006370| 72 6b 2e 20 20 41 73 20 | 70 72 6f 6d 69 73 65 64 |rk.  As |promised|
|00006380| 2c 20 74 68 65 20 70 72 | 6f 67 72 61 6d 3c 63 61 |, the pr|ogram<ca|
|00006390| 6c 63 75 6c 61 74 65 73 | 20 74 68 65 20 6f 70 74 |lculates| the opt|
|000063a0| 69 6d 61 6c 20 73 6f 6c | 75 74 69 6f 6e 2e 20 20 |imal sol|ution.  |
|000063b0| 49 66 20 79 6f 75 20 73 | 65 74 20 75 70 20 74 68 |If you s|et up th|
|000063c0| 69 73 20 65 78 61 6d 70 | 6c 65 39 63 6f 72 72 65 |is examp|le9corre|
|000063d0| 63 74 6c 79 2c 20 79 6f | 75 72 20 6f 70 74 69 6d |ctly, yo|ur optim|
|000063e0| 69 7a 65 64 20 6f 62 6a | 65 63 74 69 76 65 20 73 |ized obj|ective s|
|000063f0| 68 6f 75 6c 64 20 62 65 | 20 24 31 32 2c 37 33 32 |hould be| $12,732|
+--------+-------------------------+-------------------------+--------+--------+
Only 25.0 KB of data is shown above.